Dear Artik,
thank you for your reply.
I did some experiencing and I might have found a workaround for my requirement. I haven't used the ToggleButon yet but I did use the command button instead.
I wrote the following code (please forgive me, if I did mistakes!!! I am new to VBA) and it looks like the following:
I created two buttons 1 & 2 and put a caption "X" into it and enlarged it to be aligned with the size of the button itself and I use boolean to switch between black and white,
so to hide or show the X.
As I need to write the value into a cell and then get it back again, I used also the range command and tried it on a second button and it behaves as expected.
Maybe not the most sophistcated way to solve a problem but at least a workaround
thank you very much,
Mike
Bookmarks