Togglebutton

[Southernw2002]

I seem to have a problem with togglebuttons...

I have togglebutton on sheet 1 that changes the cell text on sheet 2

Please Login or Register  to view this content.

When I start the workbook, I need to toggle the button before it actually starts to work correctly ... sometimes it starts with a single toggle which now means the on/off result is the opposite to what I want.

How would I fix this other than a entry in Open_workbook... as there are over 150 toggle buttons in the sheet ?

[TMS]

Put

Please Login or Register  to view this content.

in your Workbook Open event handler.


Regards, TMS

[Southernw2002]

Hi TMS ... tried that and it appears that I have set state and text for each toggle ... was hoping for a easier way as that's a total of over 150 entries.

A

[TMS]

Sorry, missed that. Please post a sample workbook.

Regards, TMS

[Andy Pope]

If the problem is simply one of the number of toggle buttons then you can loop.

Please Login or Register  to view this content.