MsgBox and find Info

[Darren]

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

[mdmackillop]

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