Help with search in VBA desparatly needed

[dan653]

hi,

basically i have a customer database using excel/vba
there is a userform where the user enters data into named textboxes (eg name, address phone number) which are linked to excel cells, they are stored in excel under "name", "address" etc...

what i have then done is make a combo box in another userform, which is linked to all cells under "name"... so you can select a name...

HOWEVER what i would like to do is that when you click a button it brings up a userform, and fills in the text boxes with the name of the person that has been selected, then it look across the columns of that persons name in excel to get there address & phone number etc... then fill in the boxes..

i am extremely stuck, because i have managed to link the cells so they go from VBA to excel, but i cant seem to do it the other way round !!!

i'd grately appreciate someones help... p.s im really dumb when it comes to computer code... *(this is my A level coursework)

 

[Damon Ostrander]

Hi dan653,

When you refer to "..fills in the text boxes with the name of the person that has been selected.." do you mean selected on the worksheet, or in the other userform? Or do you have the other userform linked in such a way that selecting a name in its combobox causes the corresponding cell on the worksheet to be selected? Do you want both userforms to be open at the same time?

Damon