option button

Hello, I created a UserForm with 3 option buttons, and it works fine. When The UserForm is called, the box pops up, and I can click on the buttons and continue. What I would like to do is select the option button by keyboard instead. I can tab through each option, but the tab seems to...

Hi all I have created few option buttons which I would like to be scrollable I have created scroll bar and it work fine. But when I scroll down, my option button not moving How to make the button move together with the cells?

Hi, As a complete newbie I really seem to be struggling with this problem and am hoping that someone has a nice easy answer. I have a sheet which is essentially being used as a questionnaire. On the sheet are a number of group boxes which each contain up to a maximum of 8 option buttons (all...

Hi All, I want to write a VBA code that will place ActiveX Frame directly onto the worksheet and then add 3 Option Buttons from Toolbox into that frame. I could not find an answer searching through the web... Also when trying to record macro and see the code it did not record placing the...

Guys, I wonder if anyone can help...I have created this code from snippets and my own knowledge to add the information in a userform to a spreadsheet, simple columns etc... I would like to know: If there was a quicker and more efficient way of completing what has been done in the routine...

I have the following: * a drop-down list (linked to cell M1) * an Image ActiveX Control container (generated with the Camera button, as i assume that will be the same) When I select alternatives in the drop-down list different images appear in the Image containter. I have stored the images in...

Hello, I'm trying to make a dynamic questionnaire. Depending on previously answered Questions, different questions shall be asked later on. To only see the relevant questions I hide all the questions except for the first one in the beginning and unhide the relevant questions as i go along. The...

Hi, I've created 1 sheet containing 20 sections with 5 Options Buttons each. I need to duplicate this sheet, so I've used the Move or Copy feature to copy/paste this sheet. Unfortunately all the Option Buttons get messed up, and if I change one of them in "Sheet 1" it also changes it in "Sheet...

I have an equation that I would like to be able to have spit out 3 different outputs depending on which opion button is highlighted (Standard, Conservative, Aggresive). I cannot seem to get the equation to work for Conservative or Aggressive. Any help would be great.Tyler Private Sub...

Hi All – </SPAN></SPAN> I’m hoping you can help correct this problem. I have a large workbook that will be delivered to several hundred users and requires many data entry fields, meaning the workbook and each of its worksheets need to be protected. On one of the worksheets, users of Excel 2007...

Hi all, New to posting on these forums, though been a regular viewer for a few months now. I have a rather basic question, or so I think, but struggling to find the answer anywhere! I want to create an excel doc at home (using excel 2013) which will be a test style doc, featuring option...

Hello, I Have a code for a userform which inserts textboxes and listboxes values each time I press ok, row by row. In the userform I have two optionsbuttons, and I would like that in one of the columns the text to appear red or green dependently what button I've chosed. My code is this: [ Dim...

<tbody> product comment action financials xyz a b c d e f red red yxz a c d ge as dg ae ag red amber abc a adf adag ada amber green </tbody> hi i have a table similar to above. in the action and financials column, i would like to add the option to select three colours (red, amber...

My userform is performing backwards if the option button for whole is set to true it searches for partial, if its set for part it searchs whole. Steping through the case select does not seem to be recognizing true and false correctly. I did verify that i didnt name them backwards. optWhole is...

Hello, I think this is a very simple question to answer and maybe I'm just missing something. I have created a userform with an OK button: Private Sub cmdOK_Click() If optStraight = False And optBrick = False Then MsgBox "Please select a pattern" Else Unload frmPattern...

Hi! I need a little help about option buttons: I've this User Form: and the cod on the command button is: Private Sub CommandButton_Click() If OptionButton1 = True Then If OptionButton4 = True Then Welcome.Hide UserForm1.Show Load UserForm1 ElseIf OptionButton5 = True Then...

In Microsoft's infinite wisdom of fixing something that wasn't broken, I no longer know how to add multiple groups of Option Buttons (Radio buttons) easily. In 2003: I would add an Option button, remove the stupid "Option Button 1" text caption, and copy/paste however many buttons I would...

Hi all, I have this simple code (in a Module) that currently references "A2" & "A3" for either "buy" or "sell". Instead I want it to use the OptionButton for either true or false to determine if it is a buy or sell. I don't want the OptionButton to put a value in a cell to determine if it is...

Hi all, How can I use a function to reference a Option Button? Basically what I want to do is if "Buy" is selected, use the bid & if "Sell" is selected use the offer. How can I have the result update in "A1" simply by clicking the Options buttons? Cheers, O

I have a spreadsheet originally created with Excel 2000 or earlier, but now running in Excel 2010 on a Windows 7 machine. One of the sheets in this workbook has several dozen group boxes created from the Form Controls menu. Inside each group box are exactly two option buttons also created from...