Good evening.
I'm trying to create a form using option buttons (see attached)
As an amateur on how to use option buttons properly , much less organizing them to make them more presentable. I'm also faced with having to add unnecessary columns in order to get certain areas to line up.
I must let you know that i'll be using this form constantly after construction to print out.
Can anybody offer me any advise please into what i'm doing wrong.
Thanks in advance
Read up on using Named Ranges to create Data Validation lists.
On sheet 2 I've put your 3 groups of items in a list and given each group a "name". (See Insert > Name > Define)
Then I used those lists to create drop down data validation selection boxes on your sheet1.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks