in EXCEL 2000
I have a large database with customer names, address, phone no.,
and so on, 8 columns total. In a userform the customer name is chosen
from a combobox and entered, the balance of the customer information is
then pulled out of the database using "VLOOKUP" and applied to the
worksheet. I now need to change some of the data for some of the
customers but the user easily gets lost looking through the database.
I would like to create another userform that would allow the user to
find the customer and edit the phone no. or address or contact name.
And then the updated info would be changed in the database. I am not
sure how to replace the old data with the new data w/ code. I also used
The dataform but it will not give me the results desired, I really need
to do this with vba I think.
Best Of Luck,