Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking the status of a checkbox in a user form
Good afternoon!
I wonder could some clever person confirm that I'm using the correct syntax? I have a user form called FolderForm - it contains a number of checkboxes, one of which is named "DirectEnttyCheckBox". When I show the form, I check the status of the box with If DirectEntryCheckBox.Value = xlOn Then MsgBox ("Direct Entry") 'other code... End If but when I display the form, check the box, and click the OK button (called "OKButton", which runs a procedure containing the above code, plus validation checking for other checkboxes too) the message "Direct Entry" isn't displayed. While I'm on the subject, can anyone also suggest how I set the focus to "OKButton"? I tried "OKButton.setfocus" but it didn't make any difference. Can anyone see what I'm doing wrong? Regards & thanks in advance Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional adding by checking status | Excel Discussion (Misc queries) | |||
Clear a Checkbox in a a user form | Excel Discussion (Misc queries) | |||
Checking Protect status | Excel Programming | |||
Status Message User Form in Excel '97 | Excel Programming | |||
creating a checkbox control on a user form using VBA | Excel Programming |