Making a long list of option buttons

[lotily]

Good day to all and greetings from Finland!

This is a question about multiple option buttons in one list.

I need to make a quite long list (at least 200rows) and I need one cell in each row to have three option buttons to indicate three different status for that row. Like "OK","In Progress". "Pending"... or something equal.
How do I do that in proper way? Of course I can add three buttons to a cell, adjust and align their position, add an group box(or edit the property group name) and then repeat that 200 times! But it seems quite a fools work to do!! I Have tried to expand one button set by dragging it with mouse, but all it does is copy and then my buttons are all in same group, not good. So copying the boxes wont save me, because then I need to manually separate that group in its own.
Would it be wise to do this with macro?
I have beginners skills in VBA. Am I making any sense in my very first MrExcel post?(Did I post this right?) Tips and hints are more than welcome!



--XP--Excel2000--

 

[Norie]

Might be wiser doing it with Data>Validation...

Select all the cells you want these options in.

Goto Data>Validation..., select List and enter OK, In Progress, Pending for the Source.

 

[lotily]

Thank you,

That validation trick does the job I want, only downside is those validation dropdownbox arrows which dont look so nice. Those tiny little buttons would have been so cute But anyway, I am pleased. Thanks for your help Norie and have a nice summer!