Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Check Mark
Any cell? A particular cell? Cells within a particular range?
Also, would a double-click be alright? Event code for a double-click can be written quite easily to do what you ask, but a single click is not as "smooth" acting. To do a single click would require using a SelectionChange event, but doing so would mean that if you clicked a cell by mistake, you would have to click into any other cell before clicking back into the cell where you made the mistake in order to clear it. -- Rick (MVP - Excel) "George" wrote in message ... Can I create a method that when you click on a cell it will enter a Check Mark or an X ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Check Mark
Any Cell - A double click would be OK,
is there a novice method ? Thanks "Rick Rothstein" wrote: Any cell? A particular cell? Cells within a particular range? Also, would a double-click be alright? Event code for a double-click can be written quite easily to do what you ask, but a single click is not as "smooth" acting. To do a single click would require using a SelectionChange event, but doing so would mean that if you clicked a cell by mistake, you would have to click into any other cell before clicking back into the cell where you made the mistake in order to clear it. -- Rick (MVP - Excel) "George" wrote in message ... Can I create a method that when you click on a cell it will enter a Check Mark or an X ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make the check mark boc bigger on the check box? | Excel Discussion (Misc queries) | |||
How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
How do I get a field in excel to auto complete with a check mark | Excel Discussion (Misc queries) | |||
check box, so when you click on it it inserts a check mark into t. | Excel Discussion (Misc queries) |