Using VBA to link Radio Buttons to Display an observation

**isara912** · 12-15-2008, 04:03 PM

I work in the science field and I'm trying to record an observation with some codes within a template. I have 5 different codes (A-E) to choose from and want to display the code that the person has chosen for each of the 6 compounds they are working with.
I started creating these command radio buttons with some code to display the results in part particular cell, but I would need to do this 30 times linking each group together to get what I want. I know there's an easier way to do this but I'm not sure how so I'm sending this thread to get someone's help.
Please take a look at my sheet and let me know how I can get my desired results.

Thanks in advance

**stanleydgromjr** · 12-15-2008, 04:26 PM

isara912,

See the attached workbook "Data Validation - Using VBA to link Radio Buttons to Display an observation - isara912.xls".

Data Validation may work for you depending on your requirements.

Have a great day,
Stan

**isara912** · 12-15-2008, 04:36 PM

Stan,

Yes, this is how I started but the user doesn't want to pick from a pull down, they want to simply click on a letter and go. This is why I wrote about using the radios. Thanks for the idea, but I can't use that one. Can you help me with the radios?

Thanks,
Isara

**stanleydgromjr** · 12-15-2008, 04:50 PM

isara912,

Try the attached workbook.

Double-Click on a cell in range D5:H10

Have a great day,
Stan

**isara912** · 12-15-2008, 04:57 PM

It's kinda cool, but I don't think the person will go for that option either. They are very ergonomic and want as few clicks as possible, that's why validation wouldn't work. I'm sorry to be a pest, but I still think I should go with what they are asking me for. Sorry.