View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
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.