Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Helpful userform tricky to program
As an added benefit to my users, I thought I'd be a nice guy and add in a
City, State and Zip browser, where the user picks the state, then the city, then the zip out of comboboxes. Then, once found, can add any piece separately to the section of the program they are in. The problem is there are several places I want to use this, so there are several places in which the user could be sending the information found to. For instance I have a "License" userform in which the user enters all their personal/company information (or in some cases, the sales manager enters their clients company information so they can complete orders for said company). In another example, I have a customer information worksheet in which the user would enter the delivery address of his clients. So, in short, I need to be able to pass my City/State/Zip userform three variables that dictate where the user wants to send the City, the State and the Zip once they've found them. It has to be able to send to either cells or text fields on a userform. Any suggestions are greatly appreciated! Thank you CB Hamlyn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is AutoFill helpful | Excel Discussion (Misc queries) | |||
Helpful New Functions: ALL and ANY | Excel Worksheet Functions | |||
tab in userform locks program | Excel Programming | |||
Can I program a userform via spreadsheet? | Excel Programming | |||
Repost: Looking for info on how to program a userform to use filters | Excel Programming |