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