Checking the status of a checkbox in a user form
Doh!
I should have used "True/False" instead of "xlon/xloff"
Am I correct in thinking that the latter is used for checkboxes embedded in
a worksheet?
However, my second question from the previous post still applies. If I don't
set the "Daeault" property for the OKButton to "True", how can I subsequently
set the focus to this button?
Thanks again, and excuse my Homerability (with apologies to anyone called
Homer, other than Homer S!)
"Peter Rooney" wrote:
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
|