Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form with CheckBoxes
Can someone advise why this doesn't work; the userform (AskReClearData) shows
up okay, but when I check the 'CheckBoxClearCS' within the form (done in a frame via the Control Toolbox) and then hit ok, the code essentially skips the 5th line (re clear contents). If the checkbox is NOT selected and I hit OK, then the code runs correctly. Private Sub OKButton_Click() Application.EnableEvents = True If CheckBoxClearCS.Value = True Then Worksheets("MMS for CS").Activate Range("O3").ClearContents Else MsgBox ("Not checked") Worksheets("MMS for CS").Activate Range("A1").Select End If CheckBoxClearCS.Value = 0 AskReClearData.Hide End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to clear all checkboxes on a form? | Excel Worksheet Functions | |||
Form Checkboxes are not maintaining cell link | Excel Discussion (Misc queries) | |||
Adding Checkboxes to a Form | Excel Programming | |||
VBA Beginner: Help with Checkboxes on created User Form | Excel Programming | |||
How to keep the Checkboxes selected by the user unchanged even after closing the userform | Excel Programming |