LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
packat
 
Posts: n/a
Default resize control checkbox with cell

First question:
One of the tab in my workbook has several checkboxes
arranged in a number of columns.
One of the set is over the cells, say, A1:A20.
I would like to attach these checkboxes to the cell they
belong to so that they will have exactly the same size with
their cells, and resized along with the cells.
Is this possible?



Second question:
How much overhead does control checkbox has over simply
using cell.value = "Y" or "N" ?

I just saw an answer to another post concerning toggling a
cell between "" and "X". If this works, I could remove all
those checkboxes.

The solution is to add a block of code to the
Worksheet_SelectChange routine. I managed to extend the
code to work for multiple cells within the given range.
However, this code doesn't seem to work if there are
Application.Enables = False/True statements in the routine.


Thanks,
pac



 
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
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
How do I setup a cell in Excel as a checkbox w/o a form/activex c. Arno Rite Excel Discussion (Misc queries) 15 November 27th 06 08:50 PM
Checkbox not part of cell. (???) Cells can move "underneath". (!!!) Thomas G. Marshall Excel Discussion (Misc queries) 4 December 18th 04 04:15 PM
How do I get one cell to record the time another cell was changed. Reigning in Seattle Excel Discussion (Misc queries) 1 December 17th 04 07:45 PM
copy a cell value not its function KC Mao Excel Discussion (Misc queries) 2 December 4th 04 04:30 AM


All times are GMT +1. The time now is 05:39 AM.

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

About Us

"It's about Microsoft Excel"