Shapes as a Toggle Button?

[klutz]

Hello Freinds,

Is it possible to use a shape inexcel as a Toggle Button?

Toggles can't be formated as nicely as shapes can be.:*)


-Klutz...

[Artik]

For example (in attached)

Artik

[Bob Phillips]

You can also do it without changing the shape by having a Static Boolean variable in the procedure which gets toggled


Static fToggle As Boolean

fToggle = Not fToggle

[Artik]

xld, but when you close file... ;-)

Artik

[Bob Phillips]

Yes, it will start afresh, that seems reasoanble to me. Of course, the state could be persisted and reinstated if absolutely necessary.

Anyway, it was presented as another option, yours is good, mine is good too, they are alternative approaches.

[klutz]

Are the possibilities here at this forum with contributors like you guys. Thanks.

Both are kool options...:*)