Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Upon mouse click a checkmark appears in a square.

I want to be able to have a square or rectangel in a cell, that when it is
clicked by the user with the mouse pointer, a checkmark appears in the box.
How is this done? It would also be nice if when the box is clicked, the
checkmark appears in the square and in another cell next to the box some text
appears that relate to the checked box. Please let me know how to do this.
I have seen it done in forms, but have not been able to see the codes.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Upon mouse click a checkmark appears in a square.

Just use regular Check Box control, then use its _Click event to run code or
its LinkedCell to control the text in another cell.

NickHK

"rbbbbeee" wrote in message
...
I want to be able to have a square or rectangel in a cell, that when it is
clicked by the user with the mouse pointer, a checkmark appears in the

box.
How is this done? It would also be nice if when the box is clicked, the
checkmark appears in the square and in another cell next to the box some

text
appears that relate to the checked box. Please let me know how to do

this.
I have seen it done in forms, but have not been able to see the codes.



Reply
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
Click 1 Excel square, computer highlights 3 vertical squares, why Calbobi Excel Discussion (Misc queries) 1 January 19th 10 12:15 AM
Menu which appears when you right mouse click in excel sheet Irish RN Excel Discussion (Misc queries) 1 July 8th 09 05:40 PM
Insert a note in excel and it appears when the mouse is over the c MMM Excel Discussion (Misc queries) 4 December 22nd 06 10:29 PM
Move cell info from one worksheet to another buy click a checkmark Sherm Excel Programming 3 November 17th 05 02:10 AM
Mouse Over Graph, Capture Information on Click(Double Click) Dean Hinson[_3_] Excel Programming 1 December 6th 04 04:49 AM


All times are GMT +1. The time now is 03:42 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"