Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Editing controls after testing
This is probably a really basic answer, but I'm pulling my hair out... Here's
a "for example": I'm trying to create a form, and I added a checkbox. If the box is checked, set cell B5 to "10". I added the control. Double clicked to bring up VB Editor. Wrote the code under "CheckBox1_Click", then ran the code to test it. It ran without errors, so I went back to the workbook and saw that it worked perfectly, except I put the checkbox slightly overlapping B5, so I need to move the control. Except now I can't select the control anymore! It either checks or unchecks it. I can't move it, I can't set properties for it, etc. How do I get back to the "editing" status of the control rather than the "usage" status? I know this has got to be a really stupid answer - there's no way that just testing code would make the object no longer edit-able. I just can't figure out how to get back to edit mode. HELP! TIA, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Testing | Excel Discussion (Misc queries) | |||
TESTING | Excel Worksheet Functions | |||
Testing | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
Event procedures for controls added with Controls.Add | Excel Programming |