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