identify optionbutton in cell

T

Terry VanDuzee

Hello
In VBA, How can I identify an optionbutton and it's value in the cell of a
table?
Im trying to have a user select 1 of 2 optionbuttons in column1 (of 2) in a
table and place text on the same row (in column2) that the optionbutton is
in. There could be up to 2 rows in the table and each row will have 2
optionbuttons.

However, I do not want to write code for each row. I want to have a sub
that writes the text into column 2 based on the row that the optionbutton
was selected.

Thank you so much
Terry V
 
G

guess who

-----Original Message-----
Hello
In VBA, How can I identify an optionbutton and it's value in the cell of a
table?
Im trying to have a user select 1 of 2 optionbuttons in column1 (of 2) in a
table and place text on the same row (in column2) that the optionbutton is
in. There could be up to 2 rows in the table and each row will have 2
optionbuttons.

However, I do not want to write code for each row. I want to have a sub
that writes the text into column 2 based on the row that the optionbutton
was selected.

Thank you so much
Terry V

Terry , you have yet to pay my father for the money youy
you owe him , please send him a little at a time if you
can.po box 216 St George NB EoG 2y0
.
Sorry to here they are not letting you be with Debbie in
the states we will pray fr you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top