#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
User Forms Joanne New Users to Excel 18 July 5th 07 12:42 AM
user forms Obi-Wan Kenobi Excel Discussion (Misc queries) 0 March 21st 06 08:28 PM
User Forms Runner77 Excel Discussion (Misc queries) 1 January 12th 06 06:20 AM
user forms Runner77 Excel Discussion (Misc queries) 0 January 12th 06 04:31 AM
VB user forms Madasu Excel Programming 4 January 11th 04 10:47 PM


All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"