
September 21st, 2005, 01:30 AM
|
|
Registered User
|
|
Join Date: Jun 2004
Posts: 3
Time spent in forums: 3 h 36 m 42 sec
Reputation Power: 0
|
|
|
List Box Help
Hi,
I created an Excel form (using VB) which has a list box and a few combo boxes. The information in the list box is referenced from the worksheet itself (addresses of different locations). Is there a way for me to set up a visual basic code that will allow the user to select the address in the list box in the form and then once they hit the "OK" macro button it will find the matching address in the Excel worksheet and input the that address next to it in the next cell?
Any ideas would help dramaticallly.
Thanks!
|