Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to notify the user if they make any changes to the userform when they
click the OK button on the userform. The userform has about 90 controls on it. Do I have to set the variable bolFormChanged = True under a Change Event for each control or is there a shortcut to doing this? Thanks in Advance! For Example, Private Sub btnOK_Click() If bolFormChanged = True Then ' notify user with msgbox Else ' Do This End If End Sub -- Cheers, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UserForm Control references as variable | Excel Programming | |||
Passing variable values to userform control | Excel Discussion (Misc queries) | |||
changing selected label on userform w/ a variable | Excel Programming | |||
UserForm not passing Boolean variable | Excel Programming | |||
Assigning the name of a userform/control to a changing string | Excel Programming |