Place the caption of a toggle button into a cell

M

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
 
L

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
 
Top