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