Prev: macros disappear in Excel 2003
Next: How do you set up backround with multiple pictures?
From: LRay67 on 15 Mar 2010 16:00
I have a checkbox that when checked I want the user to select from a combobox
and not by-pass until selection has been made. Any suggestions. Not realy a
VBA programmer. Thanks in advance.
From: Dennis Tucker on 16 Mar 2010 10:32
There are 2 standard ways to tell if a userform has been completed properly.

Method 1
OK/Continue Button is disabled - in this method the user fills in all of the
available controls. Each control's change event triggers a macro that
verifies if all the required fields are filled and enables or disables the
OK/Continue button. I use this a lot.

Method 2
OK/Continue Button is always enabled - in this method the user fills in all
of the available controls and clicks on the OK/Continue button. The
OK/Continue button triggers a macro that verifies if all the required fields
are filled properly and alerts the user if any field is not filled properly.
I want to use this method more.


"LRay67" <LRay67(a)discussions.microsoft.com> wrote in message
news:185FA238-FF16-4E83-AA66-D53A8D8122D1(a)microsoft.com...
> I have a checkbox that when checked I want the user to select from a
> combobox
> and not by-pass until selection has been made. Any suggestions. Not
> realy a
> VBA programmer. Thanks in advance.

 | 
Pages: 1
Prev: macros disappear in Excel 2003
Next: How do you set up backround with multiple pictures?