Userform flow control

[jcar]

I'm designing a macro which has a userform with controls (Listbox, ToggleBox
and TextBoxes) to enter data into a worksheet. When I write code to validate
the data, ie is a room vacant? or to change a .Text property for a control -
when I refer to a control the subroutine for that control is run immediately
because I've Changed or Clicked on that control. What is the best way to
temporarily turn off the Event trigger for a subroutine connected to a
control. I've tried Enabled = false in Properties and
Application.EventEnabled = False in code both without success. I'm stuck,
please help.

 

[Doug Robbins - Word MVP]

Show the code that you are using?

However if this if for Excel, as your use of the term "worksheet" perhaps
indicates, then it would be better to post the question to the
microsoft.public.excel.programming newsgroup as this one is for Word.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[jcar]

Thanx Doug your right. This was my first posting, and while looking around I
eventually found the answer I needed.