option buttons

I have a form with five option buttons and a list box. When each one is selected it is suppose to give a list of accounts depending on the button selected. The lists are derived from a worksheet that lists hundreds of numbered accounts. I've made two loops that find the beginning and ending rows...

Hi everybody, I need to make a macro which will insert 3 option buttons in list, gives them names and adds to each one of them another macros i made. So far i manage to do this: Sub Swtich() ActiveSheet.OptionButtons.Add(95.25, 30, 48, 17.25).Select ActiveSheet.Shapes("Option Button...

I have created a user form that looks like the following: 1. Enter Name.... 2. Enter Telephone Number.... 3. Enter Address..... 4. Select Department..... (from option buttons) - Primary - Secondary - Accounts - Overseas - Associations The department selection will...

I'm fairly new to VBA and have never used option buttons before, but I'm positive what I want to accomplish is possible. I have a form with a blank listbox and 5 option buttons. When the user opens the form and selects an option I want the listbox to populate based on the option button...

New to VBA.. I need to set a default option button value. There are three options and there is already code under a userform_initiialize(). How do I get started? Any direction would be appreciated.

Hi all, I'm trying to design a table for data entry. Line items (outputs) are pre-populated, and it is up to the user to specify which, if any, function they perform by choosing selection objects from various columns. Depending on other data, I want to control what the user is able to...

Hello One and All: I have 20 options buttons grouped and each has a unique caption. I am trying to populate a textbox on a different userform with the following code: Dim i As Integer With ActiveSheet For i = 1 To .OptionButtons.Count If .OptionButtons(i).Value = True Then...

Hi all! I am trying to create a survey using 10 option buttons (high=10/low=1) for each question (6 questions). I want to average the score at the end but the option buttons are not exclusive to each question. How can I have my 10 option buttons and the selected value be exclusive to that...

Hi, I need to group some option buttons (Form controls). Can't use ActiveX or VBA per client. (I'm using Excel 2007.) Stylistically, I can't really accept the visible, hardly-formattable group box. Is there any way to make that box invisible, or another solution to this, or am I stuck...

Hi, I have two option buttons labelled as follows: "$ - Dollar Price" & "£ - Sterling Price", these link to Cell A1. Allowing the user to pick how they want to see the prices displayed. I have a table of prices that links runs a vlookup with an IF statement based on the value in A1...

I've been looking around at online tutorials of how to set up a user form for my A Level ICT coursework spreadsheet, and have managed to get myself well and truly confused. I need the form to take the user's Name, Age, Gender and whether or not they are a vegetarian (using a combo box for gender...

I have a sheet with a group of 8 Option Buttons on it. When I first created the sheet, the buttons were numbered 1 through 8. In the process of various edits, (in other words I don't know how I did it), two of the buttons became 9 and 10. Is there a way to renumber/rename them so they...

I have two option buttons on a userform. One says yes and one says no. There are two command buttons (back and next). If the user selects yes and then clicks the next button, I want it to go to userform2. However, if the user selects NO and then clicks the Next button, I want it to got to...

I have 2 vlookup tables (A1:B2) and (A4:B5). The values in each cell are as follows: A1=Male A2=Female B1=Man B2=Woman A4=Male A5=Female B4=Bull B5=Cow Cell A7 is where i will paste either the text "Male" or "Female" into. Cell A8 is where i wish to see the result displayed. Question: How do...

I have a workbook with a number of sheets, two of which are "Details" and "Details (cont)". Based on the inputs in sheet "Details" I would like the second sheet to be visible or hidden. More specifically, I have created a Group box (from the Forms toolbar) within sheet "Details" and inserted 3...

This seems like it should be easy, but none of the methods I’ve tried have worked. I have two option boxes (optYES and optNO as a response to the question “Is the building sprinklered?”). Then I have a combo box (cmbOccupancyGroup) and a label (lblTravelDistance). From the combo box, I would...