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
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 to
Hi Robert,
Thanks
On Wed, Oct 27, 2010 at 2:22 AM, roberto mensa robb@gmail.com 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
Thanks!
--
Sent from my Nokia phone
--Original message--
From: Sergio Abadesso groups.abade...@googlemail.com
To: excel-macros@googlegroups.com
Cc: Dave Bonallack davebonall...@hotmail.com
Date: Tuesday, October 26, 2010 11:01:40 PM GMT+0200
Subject: Re: $$Excel-Macros$$ Fwd
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)