populating textboxes - Xtreme Visual Basic Talk

05-16-2002, 08:07 AM

dmar

Guest

Posts: n/a

populating textboxes

Hey everyone,
I am in need of help. What I am doing is, I have a form which I am using text boxes to collect data, the data is then being stored on a worksheet. The data is also listed in a listbox. Is there a way to click on a certain entry in the list box and have that information for that entry from the worksheet populate the original textboxes? I am collecting names and addresses and such.
I hope I explained it correctly. I am using VBA / Office 97.
Any help would be greatly appreciated.
Thanx.

05-16-2002, 04:37 PM

xxxxxq

Guest

Posts: n/a

Yes you can.

The easiest way is to alter the program so that each record starts with a unique identifier (i would recommend the row index) then include this as the 1st value in the listbox (or the 1st column). Set the width of the 1st column to 0. When the user selects the clicks the item you can use cells method to read the values. ie:

Code:

private sub ListBox_Click()
  textbox.value = cells(listbox.value,1).formula
end sub

the example above presumes you have used the 1st column as the row number.

05-17-2002, 08:01 PM

Brendon

Guest

Posts: n/a

That's strange, correct me if I am wrong but to assign a value to a textbox, isn't it...

Code:

textbox.text = "Value to the textbox"

Regards

05-21-2002, 08:46 AM

dmar

Guest

Posts: n/a

I got it! Thanks for the help people

05-21-2002, 11:54 AM

xxxxxq

Guest

Posts: n/a

Quote:

Originally posted by Brendon
That's strange, correct me if I am wrong but to assign a value to a textbox, isn't it...

Code:

textbox.text = "Value to the textbox"

Regards

You can assign to value in excel............ but yeah your right