Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a form with multiple textboxes. When initializing the form, I use
values from the worksheet to fill the textboxes. Each of these initialization steps triggers the TextBox_Change event, which is unnecessary during the initialization. Can I easily stop the TextBox_Change event during this initialization? The code following works, but seems a little bulky and I would prefer something more efficient or eloquent. Oh, and it's a pain to have to write the TextBox_Change code over and over for multiple textboxes. What I have done is this (with x being a public variable): x = false ....code that triggers Textbox_Change x=true Textbox_Change If x = true then ....code Else 'do nothing End If Thanks, drhalter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TextBox_Change a little premature! | Excel Programming | |||
suspend a routine | Excel Programming | |||
Suspend Execution | Excel Programming | |||
Suspend code | Excel Programming | |||
Screen suspend | Excel Programming |