Writing a Macro for a form.

April 28, 2011 at 16:42:17
Specs: Windows XP
I am making a form that will act as a Rolodex. In the first box, you will put in a name or location, and then hit a find button. Below that, I then have Headers named Number 1, Number 2, and Number 3 with three text boxes underneath that which will populate with different numbers.

I have listed the locations in a different spreadsheet in row A with Number 1 in row B, number 2 in row C, and number 3 in row D.

How can I write a macro that when I put a location in my first box it will search the second spreadsheet in row A and then populate the boxes with the phone numbers from that same worksheet from the different rows? Any ideas?

See More: Writing a Macro for a form.

April 28, 2011 at 19:16:43
There are no such things as Row A, Row B, etc.

Rows don't have letter designations, columns do.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question