Hi Everyone,
Lets say i have, listbox1,textbox1,textbox2 and commandbutton1 in
userform1. when i click on commandbutton1
Dim trddate As Variant
trddate = Date
For Each cell In reqd.Columns(1).Cells
If cell.Value = trddate Then
ListBox1.ColumnCount = 11
ListBox1.AddItem "PIT " & cell.Offset(0, 1).Value
ListBox1.List(ListBox1.ListCount - 1, 2) = cell.Offset(0, 2)
CPitUF.ListBox1.TextColumn = 9
End If
Next
whenever I click on Listbox1, listbox bound column will display on
textbox1 and listbox.text will display on textbox2. i want to find the
address of those items in the sheet(range of the item in the listbox)
so that every time i click on the list box that will find the address
of the item in the worksheet and type "X" on the offset(0,1). So is
there a way to display on textbox3 listbox column 11 value.List box as
follow
Column
1 2 3 4 5 6 7 8 9 10 11
A B C D E F G H I J K
So once I click on listbox
Textbox1=C, Textbox2= I and Textbox3=K

Is that possible?
Thanks for the help

Instead of having 11 columns in .listbox1, include a 12th column. Put the row
number (or address or whatever you want) in that 12th column. Then make sure
that the columnwidth for that 12th column is 0, so it's hidden.

Then you can just look at the column 12 whenever you need it.



" wrote:

Hi Everyone,
Lets say i have, listbox1,textbox1,textbox2 and commandbutton1 in
userform1. when i click on commandbutton1
Dim trddate As Variant
trddate = Date
For Each cell In reqd.Columns(1).Cells
If cell.Value = trddate Then
ListBox1.ColumnCount = 11
ListBox1.AddItem "PIT " & cell.Offset(0, 1).Value
ListBox1.List(ListBox1.ListCount - 1, 2) = cell.Offset(0, 2)
CPitUF.ListBox1.TextColumn = 9
End If
Next
whenever I click on Listbox1, listbox bound column will display on
textbox1 and listbox.text will display on textbox2. i want to find the
address of those items in the sheet(range of the item in the listbox)
so that every time i click on the list box that will find the address
of the item in the worksheet and type "X" on the offset(0,1). So is
there a way to display on textbox3 listbox column 11 value.List box as
follow
Column
1 2 3 4 5 6 7 8 9 10 11
A B C D E F G H I J K
So once I click on listbox
Textbox1=C, Textbox2= I and Textbox3=K

Is that possible?
Thanks for the help

--

Dave Peterson

And if you're using .rowsource to populate the listbox, you should know where
the range starts. You can adjust it by adding the .listindex to that row
number--discounting columnheads, too.

Dave Peterson wrote:

Instead of having 11 columns in .listbox1, include a 12th column. Put the row
number (or address or whatever you want) in that 12th column. Then make sure
that the columnwidth for that 12th column is 0, so it's hidden.

Then you can just look at the column 12 whenever you need it.

" wrote:

Hi Everyone,
Lets say i have, listbox1,textbox1,textbox2 and commandbutton1 in
userform1. when i click on commandbutton1
Dim trddate As Variant
trddate = Date
For Each cell In reqd.Columns(1).Cells
If cell.Value = trddate Then
ListBox1.ColumnCount = 11
ListBox1.AddItem "PIT " & cell.Offset(0, 1).Value
ListBox1.List(ListBox1.ListCount - 1, 2) = cell.Offset(0, 2)
CPitUF.ListBox1.TextColumn = 9
End If
Next
whenever I click on Listbox1, listbox bound column will display on
textbox1 and listbox.text will display on textbox2. i want to find the
address of those items in the sheet(range of the item in the listbox)
so that every time i click on the list box that will find the address
of the item in the worksheet and type "X" on the offset(0,1). So is
there a way to display on textbox3 listbox column 11 value.List box as
follow
Column
1 2 3 4 5 6 7 8 9 10 11
A B C D E F G H I J K
So once I click on listbox
Textbox1=C, Textbox2= I and Textbox3=K

Is that possible?
Thanks for the help

--

Dave Peterson

--

Dave Peterson

On Jan 29, 7:24 am, Dave Peterson wrote:
And if you're using .rowsource to populate the listbox, you should know where
the range starts. You can adjust it by adding the .listindex to that row
number--discounting columnheads, too.



Dave Peterson wrote:

Instead of having 11 columns in .listbox1, include a 12th column. Put the row
number (or address or whatever you want) in that 12th column. Then make sure
that the columnwidth for that 12th column is 0, so it's hidden.

Then you can just look at the column 12 whenever you need it.

" wrote:

Hi Everyone,
Lets say i have, listbox1,textbox1,textbox2 and commandbutton1 in
userform1. when i click on commandbutton1
Dim trddate As Variant
trddate = Date
For Each cell In reqd.Columns(1).Cells
If cell.Value = trddate Then
ListBox1.ColumnCount = 11
ListBox1.AddItem "PIT " & cell.Offset(0, 1).Value
ListBox1.List(ListBox1.ListCount - 1, 2) = cell.Offset(0, 2)
CPitUF.ListBox1.TextColumn = 9
End If
Next
whenever I click on Listbox1, listbox bound column will display on
textbox1 and listbox.text will display on textbox2. i want to find the
address of those items in the sheet(range of the item in the listbox)
so that every time i click on the list box that will find the address
of the item in the worksheet and type "X" on the offset(0,1). So is
there a way to display on textbox3 listbox column 11 value.List box as
follow
Column
1 2 3 4 5 6 7 8 9 10 11
A B C D E F G H I J K
So once I click on listbox
Textbox1=C, Textbox2= I and Textbox3=K

Is that possible?
Thanks for the help

--

Dave Peterson

--

Dave Peterson

Thanks to your reply.Honestly I didn`t know that I can get
"listbox1.column(0)" value:)But I figured out after your reply,thank
you.