Hi,
I need your help . i am also making form like this . but what is this object
like object.list(row,column)
and why we are consider column as zero and one
On Wed, Oct 27, 2010 at 2:31 AM, Sergio Abadesso <
groups.abade...@googlemail.com> wrote:
> Hi Dave,
>
> you have to consider that the pro
Hi Robert,
Thanks
On Wed, Oct 27, 2010 at 2:22 AM, roberto mensa wrote:
> try:
>
> Private Sub CommandButton1_Click()
> Dim item, rng As Excel.Range
> For item = 0 To ListBox1.ListCount - 1
> If Me.ListBox1.Selected(item) = True Then
> Set rng = Sheet2.Range("A" & Rows.Count). _
>
Hi Dave
Thanks a lot for giving solution .
On Wed, Oct 27, 2010 at 2:31 AM, Sergio Abadesso <
groups.abade...@googlemail.com> wrote:
> Hi Dave,
>
> you have to consider that the property object.List(row, column) has two
> arguments. The first argument is to pass the row number and the second is
Thanks!
--
Sent from my Nokia phone
--Original message--
From: Sergio Abadesso
To:
Cc: "Dave Bonallack"
Date: Tuesday, October 26, 2010 11:01:40 PM GMT+0200
Subject: Re: $$Excel-Macros$$ Fwd: Practice
Hi Dave,
you have to consider that the property object.List(r
try:
Private Sub CommandButton1_Click()
Dim item, rng As Excel.Range
For item = 0 To ListBox1.ListCount - 1
If Me.ListBox1.Selected(item) = True Then
Set rng = Sheet2.Range("A" & Rows.Count). _
End(xlUp).Offset(1, 0)
rng.Value = Me.ListBox1.List(item, 0)
rng
