LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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,
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Testing Rick Rothstein Excel Discussion (Misc queries) 13 December 29th 09 10:45 PM
TESTING Eamon Excel Worksheet Functions 0 July 11th 08 03:41 PM
Testing Richard Wrigley Excel Discussion (Misc queries) 0 November 1st 06 09:45 PM
ActiveX Controls vs Form Controls Alex Excel Discussion (Misc queries) 1 January 11th 06 08:46 AM
Event procedures for controls added with Controls.Add John Austin[_4_] Excel Programming 1 March 9th 05 03:31 PM


All times are GMT +1. The time now is 11:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"