Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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, Ashu |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Database Record add | Excel Discussion (Misc queries) | |||
How do I email just one record from an excel database. | Excel Discussion (Misc queries) | |||
Printing a database record | Excel Discussion (Misc queries) | |||
edit a record like 17.00 gbp so it becomes 17.00 using a formula | Excel Discussion (Misc queries) | |||
Cannot Record a Macro or Edit VBA | Excel Programming |