G
Guest
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
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