I am creating a knowledge assessment form listing multiple questions that each have 2 to 4 Option Buttons representing the answers. What I would like to do is allow the user to only select the (radio) button and no other part of the Option Button (text).
How would I achieve this?
I have NO VBA knowledge nor code writing skills so the simpler the better.
Currently using 2010 Excel and the 'Form Controls' not the 'ActiveX Controls'...they seem a little easier to use.
The way I would do this is to have no text in the option button and put the text in an adjacent cell, which would be locked and the sheet protected. You can uncheck the option to allow the user to select locked cells. If you don't have code yet, you don't need code to do this.
Here is a sample.
That solution hadn't even occurred to me, simple yet effective.
How are the properties set on the radio buttons in your example?
I am not able to get the radio buttons on my sheet to perform as yours do in your example....
I set the full sheet to 'locked' and the 'option buttons' to 'unlocked' and then protect the sheet with only "Select Unlocked cells" checked, but I get the "this sheet is locked"warning. I must be missing something in the properties that you have set differently.....
Last edited by kmcbriarty; 09-24-2014 at 12:31 PM.
I did not link the buttons to a cell, and I am guessing you did. If you set the buttons to link to a locked cell, then you will get the warning when you click a button, because it will try to update that cell. You will have to link to an unlocked cell. If you don't want the user to access the linked cell, you could put it on another sheet and hide that sheet.
That would make sense...Thanks Jazzer.
Works perfectly once I reassigned the link to an unlocked cell, brilliant.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks