Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Click on a cell to get a check mark then...
I need to attach some Visual Basic code to a group of cells so the following
will happen. The group of cells is going to be named ClickRange. In this example, I will say the range corresponds to cells B3 through B8. When a user left-clicks on B3 or B4 or B5, etc. I would like a check mark to appear. (I am thinking that I need to format those cells to Wingdings2 and when a capital P is typed in them, a check mark will show up.) If a check mark already exists in the cell, I want the left-click to turn the check mark off. (I am thinking that the cell.value is deleted.) Then after the selection process is made by checking the cells on or off, I want to have the user click on a button at the top of the page that will hide all the rows that do not have a check mark. Can you guys help me out here? Thanks, Tofer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check Mark in a cell | Excel Worksheet Functions | |||
How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
Cannot check the check mark box in cell | Excel Worksheet Functions | |||
Increase size of a Forms Check Box (click on to enter 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) |