Place the caption of a toggle button into a cell

[mehl]

Hello --

The caption of a toggle button on a form can have two values, depending
on the state of the button.

I want to use that value in another cell of the worksheet.

Is there a worksheet function or technique to do that?

Thanks for any help.

L Mehl

 

[Chip Pearson]

You need to use VBA.

Range("A1").Value = Sheet1.ToggleButton1.Caption

 

[L Mehl]

Chip --

Thank you. I wasn't "thinking outside the cell". I can put that code on
Worksheet_Activate() and achieve the result I want.

Larry