OK, I'm delving into new territory with this...
I've figured out how to put ActiveX option buttons into a worksheet and they work great. Is it possible to have the selection from a group of ActiveX option buttons return to a cell on the worksheet?
Here's my example...
I have four option buttons contained in the GroupName "Vegetable". The four buttons are named "Corn", "Carrots", "Peas" & "Beans". When the user makes their selection, I'd like the selection to show up in a cell, say A1. What is the formula in A1?
Thanks.
bobmc
I've figured out how to put ActiveX option buttons into a worksheet and they work great. Is it possible to have the selection from a group of ActiveX option buttons return to a cell on the worksheet?
Here's my example...
I have four option buttons contained in the GroupName "Vegetable". The four buttons are named "Corn", "Carrots", "Peas" & "Beans". When the user makes their selection, I'd like the selection to show up in a cell, say A1. What is the formula in A1?
Thanks.
bobmc