Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a simple spreadsheet that contains a number of check boxes. When I
open the file, I get the following message: Microsoft Visual Basic Can't exit design mode because Control "AfterCheckingValidations" can not be created. I had a control by that name, but I deleted it and I still get the error. There are no conflicting names (i.e. A control with the same name as a variable). There are no controls by that name in any of the other open projects. Below are the only 4 sections of code that contain a name even close to the control name given by the error message (Lines beginning with * are for your reference, and are not actually a part of the code). Dim cbValue As Boolean * This is the click event of a "Check All" button on the sheet. Private Sub cmdCheckCategoryAfter_Click() cbValue = True AfterCheckingValidationsTasks End Sub * This is the click event of a "Clear All" button on the sheet. Private Sub cmdClearCategoryAfter_Click() cbValue = False AfterCheckingValidationsTasks End Sub * This routine is called by the click events of two buttons on the sheet. Private Sub AllTasks() MTRecordsTasks NCICRecordsTasks PrintLabelsTasks CertDocsTasks AfterCheckingValidationsTasks StuffEnvelopesTasks MailingValidationsTasks End Sub * This routine checks or clears the check box, depending on the state of cbValue, which is set above depending on the button clicked. Private Sub AfterCheckingValidationsTasks() TrashOldCertDocs.Value = cbValue End Sub FYI: The last routine will eventually have more check boxes, which is what makes the Check All and Clear All buttons advantageous to have. Any ideas as to what is causing this error, and how to fix it? --Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MS Excel 2003: Cant exit design mode, whats the fix? | New Users to Excel | |||
Can't exit Design mode because control 'SignCal' can not be created...? VB | Excel Discussion (Misc queries) | |||
run procedure when exit design mode | Excel Discussion (Misc queries) | |||
I can't exit from Design mode anymore | Excel Discussion (Misc queries) | |||
Enter Excel Design Mode and Exit Design Mode | Excel Programming |