View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
twintrbl twintrbl is offline
external usenet poster
 
Posts: 1
Default 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,