ToggleButton1,2,3,4,5,6

Trying to read out togglebutton caption to a cell in a spreadsheet. I can do this a line at a time but I would like to
do it within a for next loop. Something like below ? Togglebuton1_Y.Caption , Togglebutton2_Y.Caption .... become Togglebuttoni_Y.Caption

Please Login or Register  to view this content.

Thank you.

big yellow banner - upload a workbook.
where are your toggle-buttons ?

If the togglebuttons are on a worksheet then

Please Login or Register  to view this content.

If on a userform then

Please Login or Register  to view this content.

Yes these work ByteMarks.
Thank you.