optionbutton

Dear MrExcel, I have a questionnaire which includes some descriptive data like age range(for example less than 30 years) of respondents which I place them(I mean less than 30 years in persian) in Caption properties of option buttons.I need the numbers in "caption" to appear in persian. I...

Hi I recently used some code kindly supplied 8 years ago (!) by Tom Urtis http://www.mrexcel.com/forum/excel-questions/321894-userform-select-worksheet.html and it works brilliantly for my purposes - BUT only on my machine + my session/profile. On other machines or on my machine with someone...

Hi! I have a sheet called "Info" filled with A LOT of information (31000 cells!). Lets use this as an example for my questions: <tbody> ID Class Name Points Year 1 Blue A 3 1 2 Green B 4 2 3 Blue C 1 1 4 Red D 0 4 </tbody> I have a userform that has options buttons for: the class...

Hi, I'm working on a userform that creates option buttons from a range. Now I would like to set a variable, base on the caption, when clicking a option button. I tried many things, but noting seems to work for me. Can anyone help me please? My code for creating the option buttons: Private...

Hello, I have a UserForm with 14 different OptionButtons on their names are OptionButton1 to OptionButton14. If any of the buttons are select then it executes a procedure below. Private Sub OptionButton1_Click() Call OBC End Sub . . . Private Sub OptionButton14_Click() Call OBC End Sub Is...

Dear Xperts: I am a school teacher creating an excel spreadsheet with radio buttons. I have a cell,lets say D3, it has four radio buttons, and a linked cell D4, which gives the result of 1,2,3,4 based on which radio button pressed. The radio buttons are grouped. They are contained in one cell...

Hi, I have been working on a UserForm. Everything is working fine except for one thing, I have multiple OptionButtons from which you will need select 1. I want a Listbox, Textbox or Label to be populated by this choice. For instance, if you pick OptionButton1 I want Label 1 to be populated...

Hi all, I am new to VBA, using Excel 2010. I am working on spreadsheet that I need to process every month, dealing with upwards of 2000 rows of data in 45 columns. Column A lists employee names; column S lists their current job titles. I have a For... loop that examines each job title and...

Hi friends, What I need to do is, - If fruits is selected in question 1, then automatically OptionButton3, OptionButton4 & OptionButton5 should get activated and OptionButton6, OptionButton7 and cell E9 should get deactivated (means user should be restricted to use them)...

Hello folks, I'm developing a UserForm which has 19 OptionButtons. Then, I need to code some conditionals, however, it might be better if I just return the selected OptionButton from the UserForm. This is my issue! Does anyone knows if it's possible to return the selected OB from user? I...

On a userform, I have one large frame with two smaller frames inside. In each smaller frame there is a single option button. I would only want one of the other option button to be selectable, not both. How do you associate these buttons so that only one would be selectable? If they were...

Please download attached Excel file. You will find one UserForm there, run it. Two times select option 2 and choose "No" and close UserForm. 1. Why I am asked "Change it?" just after UserForm loads (no selections are made)? 2. More importantly, why I am two times asked "Change it?" when closing...

I am using Exel 2007 and have a Userform for data entry. There are 8 different frames with each frame containing 5 option buttons. I would like to prevent the user from "adding" the item unless they have choosen one of the 5 option buttons in each frame, so they would get an error message saying...

I want to create a multiple choise test in MS Excel 2007. A question is stated on top of the groupbox. 3 Optionbuttons are in that box and hold the answers in the caption. To create a list so i can compare questions and answers i create two collums; one containing the correct number of the...

Is there anyway to get an option box to return a number value instead of a true/false value. When I send it to my spreadsheet it keeps coming up as true/false and I want it to be either a 0 for false or 1 for true. Here is the code I have now: If tacknone.Value = True Then...