T
ToferKing
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
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