ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Upon mouse click a checkmark appears in a square. (https://www.excelbanter.com/excel-programming/370504-upon-mouse-click-checkmark-appears-square.html)

rbbbbeee

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.

NickHK

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.





All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com