 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / May 2008Checkbox works in one window but not another
Good afternoon -- I've designed a workbook to have checkboxes on two worksheets. Then, I wrote a macro to open the workbook in two tiled windows (so that reference info stays visible in one window when the other scrolls as the user adds more info). My problem -- the checkboxes on Sheet 1 work fine, but the checkboxes on Sheet2 don't. They only work when I switch to the other window and go that same sheet Whoda thunk? Very simple code. If the box is checked, place a value in a particular cell. But the box is unresponsive on one (active) window and, when I make the other window active and go to that sheet, it works just fine. Any idea what might be happening here? TIA Well, I figured out part of the problem. You cannot have two checkboxes with the same name active at the same time. Excel would not even show the property windows for the second checkbox in my setup, which had a checkbox1 on sheet one and a checkbox1 on sheet two. So, I changed the name of the one on sheet two and sure enough, then it would fire. However, It seemed to fire three consecutive times on one of the sheets while the other one operated as expected. I am not sure what effect that would have on any code being run since the final effect is the same on the third iteration as it is on the first, but I would like to understand why it is doing that. The reason I know it fires three times on sheet two is that I have a message box in the click event to let me know that the code did execute and I have to click the OK button three times before it passes control back to the user. Odd. At least now you know why the other checkbos didn't fire. > Good afternoon -- > I've designed a workbook to have checkboxes on two worksheets. Then, I [quoted text clipped - 12 lines] > > TIA You can forget what I just said about renaming the checkbox, it still don't work in the split window. > Good afternoon -- > I've designed a workbook to have checkboxes on two worksheets. Then, I [quoted text clipped - 12 lines] > > TIA It's a "feature/bug" of split windows. Maybe you can use freeze panes and put the control at the top??? > Good afternoon -- > I've designed a workbook to have checkboxes on two worksheets. Then, I [quoted text clipped - 12 lines] > > TIA  SignatureDave Peterson Dave -- I wish I could freeze the panes. It's a time card, and the various users want to see hours per day, per client, etc., etc., etc. so if I showed all that and froze the panel, there wouldn't be any lines showing as they scrolled down. Bummer about the "feature/bug". Thanks for the info, so I don't beat myself up trying to solve it. > It's a "feature/bug" of split windows. > [quoted text clipped - 16 lines] > > > > TIA Maybe you could replace the checkboxes from the Control toolbox toolbar with checkboxes from the Forms toolbar. You'll have to fiddle with the code, but the controls from the Forms toolbar may work. > Dave -- > [quoted text clipped - 30 lines] > > > > Dave Peterson SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.