| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting Input Change on User Form
I'm using Excel 97. I have a user form for input. It has buttons for OK
(which saves) and Cancel. But one person was clicking the X in the upper right and losing his input. So I implemented a UserForm_QueryClose (when CloseMode < 1) to make the user confirm that they wanted to exit and lose any changes. But to be friendlier I'd like to only display this confirmation if the user has actually made a change to the data. Is there some flag I can read to detect whether input has been changed or not? Thanks, Don <donwiss at panix.com. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I make a picture change based on input from a user? | Excel Discussion (Misc queries) | |||
| Trying to select a specific range based on the time value of user form input | New Users to Excel | |||
| Trouble with saving user input in an Excel Form. | Excel Discussion (Misc queries) | |||
| Change color of cell after user has input a number | Excel Discussion (Misc queries) | |||
| Help with a User Input Form | Excel Programming | |||
Threaded Mode
