Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Forms
Trying to update my Customer Concern System with new ideas
for user's when entering into system and have some thoughts for feedback if I am on right track. Step 2 requires user to select a customer contact name from list to get ph,fx,em for response activities later. Default tabstop = false Because changes to those fields do not happen, but user can change the info then press button to update the conatct info in list. What I am trying to prevent is the button happy that if no changes have been made to contact info stop the code. I see this task at hand as Afterupdate 1. Get ph,fx,em values 2. Form show values Ex: UserForm1.Ph.value = Range ("xyz").Value 3. Set cs for fields on form 4. Check if user changed values by comparing ds to frm values. 4a. If no changes were made stop 4b. If changes were made then update contact list. My goal is to keep my get formula's from the aybss because of what cs on userform fields does. Thanks for your help I have examples of how it looks if needed (jpg) Geo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Forms | New Users to Excel | |||
user forms | Excel Discussion (Misc queries) | |||
User Forms | Excel Discussion (Misc queries) | |||
user forms | Excel Discussion (Misc queries) | |||
VB user forms | Excel Programming |