LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 41
Default 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
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
Check Mark in a cell Wally Excel Worksheet Functions 1 January 19th 09 01:50 AM
How can I add active tick mark/check mark boxes in excel? gerberelli Excel Discussion (Misc queries) 2 May 3rd 08 05:16 PM
Cannot check the check mark box in cell ac Excel Worksheet Functions 1 February 15th 08 10:24 PM
Increase size of a Forms Check Box (click on to enter check mark) 718Satoshi Excel Discussion (Misc queries) 0 August 17th 07 01:52 AM
check box, so when you click on it it inserts a check mark into t. Steve Excel Discussion (Misc queries) 2 April 13th 05 09:12 PM


All times are GMT +1. The time now is 11:48 AM.

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

About Us

"It's about Microsoft Excel"