Place the caption of a toggle button into a cell
 

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

You need to use VBA.

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




wrote in message
ups.com...
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 --

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

Larry



"Chip Pearson" wrote in message
...
You need to use VBA.

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




wrote in message
ups.com...
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