Posted to microsoft.public.excel.programming

SMS

external usenet poster

Posts: 15

How to prevent and event?

In a textbox.afterupdate() event, I have a line to make the
textbox.visible FALSE. This triggers another afterupdate event. How
do I suppress this?

Private Sub TextBox1_afterupdate()
TextBox1.Text = ""
TextBox1.Visible = False
End Sub

Thank you!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Prevent event macro from executing on ALT-Enter	John Keith	Excel Programming	5	July 14th 09 03:42 PM
Prevent Corollary Event	clara	Excel Programming	1	May 9th 07 11:16 AM
Prevent automatic combobox event trigger	[email protected]	Excel Programming	0	March 9th 06 07:57 PM
prevent event procedure under condition	short_n_curly	Excel Programming	3	June 27th 05 08:38 PM
Prevent Change in Event when not needed	JK	Excel Programming	0	October 13th 03 08:10 PM

All times are GMT +1. The time now is 06:03 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us