PDA

View Full Version : MsgBox and find Info



Darren
07-03-2006, 02:54 PM
Hi Malcolm/guys/ladies

NO Clue how to
I am busy putting an invoice program together and have come to a problem area.

The problem i have is "when" cell A6 is selected i would like a message box to appear. This box is for a customer search buy name.

For Example ..... Click on A6 box appears and say we are looking for Client named "Stewart"

Typing the letters with "St" must bring up a list of possible matches from the database.

At the moment i use codes, For Eample 001 would bring up and autofill all the info for that client (Malcolm helped me with this) using Vlookup and Validation.

I would like to use an MsgBox or inputBox to fill the info


I hope i explained well enough


Kindest regards


Darren
South Africa Monday 23h54:hi:

mdmackillop
07-03-2006, 03:44 PM
Hi Darren
For this functionality I think you need a userform and a combobox, with the RowSource set to your list of names.
Give it a try and let us know if you're having any problems.
Regards
MD