To Ensure All Radio Button Groups Are Used Before Moving On.

Jan 7, 2010

I have created a survey in excel 2003. It has 70 questions on it and the user responds to the questions by clicking on a radio button. There are 4 radio buttons within a group box for each question and the user will select one of them.

At the end of 'sheet 1' with all these questions on, i have a button which the user presses to proceed to 'sheet 2'. When they press the button i want to ensure is that all questions have been answered ie: 1 of the radio buttons is selected for every question.

If one of the questions isnt answered then a pop up box will appear to tell the user they have unanswered questions and then the vba code will exit and the user stays on the question sheet (sheet 1). If all the questions are answered then the user will move to 'sheet 2'. (the reference cells for all the groups of radio buttons are within column G on sheet 1).

View 3 Replies


ADVERTISEMENT

Ensure User Selects Radio Button Before Adding Information

May 27, 2014

I have a userform for inputting information to a spreadsheet using the code below. It works fine however if the user does not select a radio button to select a score its saving the rest without it. How can I ensure the user selects a score,,,, ob10, ob8, ob6, ob4, ob2, obna.

[Code] ......

View 2 Replies View Related

Radio Buttons Macros Hyperlinks And Moving Back?

Sep 6, 2002

I'd like to insert some radio buttons in a worksheet that activate a hyperlink to a web page and then be able to go back to where I started (ie the radio button)

I can link the button to a macro which was a recording of clicking on a hyperlink. The trouble is when I hit the return arrow to return to the sheet from the web page I go back to the location of the hyperlink not where I started from.

Is there a way to do this with the buttons.

If I can rearrange the sheet to allow for more narrow columns I may be able to just use the hyperlink friendly name argument and do it that way but I'm not so sure I can insert more narrow columns without messing up the layout of the whole sheet. With a button I can float several of them over an area regardless of the width of the columns.

View 1 Replies View Related

Radio Button Alert

Nov 25, 2008

I have a chart that's being updated with different values when I cklick on different radiobuttons. When the cells that the radio button refers to is empty or the calculation in the cell have an error it pops up a message that I need to click OK to go on. Is there a way to stop these alerts by writing a script that shuts the alert messages off during each click?

View 2 Replies View Related

Should I Use A Radio Button Or Checkbox

Feb 22, 2008

I'm making a worksheet where the user has the options to select "yes" or "no". I used active x radio buttons because I feel they are more flexible. The problem I'm running in to is, what happens if there is an "unknown"? I can't find a way to "deselect" a radio button?

I tried using 2 checkboxes using the following
Checkbox 1:

If CheckBox2.Value = True Then
CheckBox1.Value = False
End If

Checkbox2:

If CheckBox1.Value = True Then
CheckBox2.Value = False
End If

The problem with this is, you have to deselect one checkbox before you can select the other. It works, but it’s a little more cumbersome then I was hoping. Is there a better solution?

View 9 Replies View Related

Excel VBA To Select IE Radio Button

Feb 18, 2014

When I select the binoculers by project the window we are disucssing with the radio button comes up (after the project number is added and sendkey to select filter - only shows one radio button). Attached is the source code of the original window and a snapshot of what it looks like.

First window - I currently have the code going to the project area (where we cannot type anything) then using sendkey to tab and enter to select the binoculers.

New window - only one radio button shows after you type a project number than hit filter.

First Window.xlsm
Original Window source code.txt
new window.xlsx
New window radio source code.txt

View 4 Replies View Related

Radio Button: Just Click To Select The Value

Nov 17, 2008

I am looking at designing a simple radio button system which allows me to fill an adjacent cell with values from a certain column - so in the example, column C is the total value, and columns D-F will ideally have a radio button which a user can just click to select the value.

View 4 Replies View Related

Radio Button Default Selection

Oct 11, 2009

I have a Userform (frmData) with 4 CommandButtons (Cmd1, Cmd2 etc) and also 2 RadioButtons (Opt1 & Opt2).

I want Opt1 to be the default selection when frmData is opened.
If Opt1 or Opt2 is selected I want that option to stay selected until frmData is closed.

When Cmd1 is selected code1 runs if Opt1 is ticked, and Code2 if Opt2 is selected.

View 6 Replies View Related

Naming Radio Button In Macros?

Mar 16, 2012

I have code in my macro that outputs a radio button for every project that is entered into the database. All radio buttons are part of the same group. I know how to give the radio button an caption name but I do not know how to give the radiobutton an actual name that I can call to. How can I do this in excel macros?

View 9 Replies View Related

Create New Radio Button Group

Sep 13, 2012

I am using the developer tools and have created a set of radio buttons that work fine.

On the same worksheet and tab I have created a second set of radio buttons but all the radio buttons are grouped as the same set.

How do I define the second group as a second group?

View 2 Replies View Related

VBA Code For Go To Next Sheet Using Radio Button

Feb 17, 2014

VBA code for go to next sheet using radio button.

View 1 Replies View Related

Recognize Which Radio Button The User Selected?

Jul 21, 2014

Within a worksheet, I have several radio buttons, allowing the user to select only one of them. Using VBA, how do I recognize which radio button the user selected?

View 1 Replies View Related

Combobox And Radio Button Reducing In Size

Sep 17, 2012

I have an issue with a combo box and radio button.

Anytime I click on either of them, they reduce in size.

It's as if it is reducing by the same ratio every time until you can't click on it anymore.

View 3 Replies View Related

Linking Drop Down List To Radio Button

Jul 31, 2008

I am building a form and want to display (or activate) a drop down list only when an radio button is active. I have 4 radio buttons and want to link to to 4 different drop downs. But only have the drop downs active if the button is clicked.

View 9 Replies View Related

Radio Button Transparency Lost When Clicked, How To Remedy

Jan 23, 2009

I have a form (worksheet with controls embedded in) and the form changes color depending on what the user clicked, problem is that button colors and cell pattern colors don't quite match.

thought I solved it by making the buttons backstyle = transparent.
However, as soon as radio button was clicked, transparency was lost.

I have named the range of the form "FormGround" so that when Service 1 is select, the Form turn a different colour. I have my subsequent buttons change to that same color as well (using the cell's color index number.

View 4 Replies View Related

How To Disable Combobox On Radio Button Click In Macros

May 19, 2009

how to disable combobox on radio button click in excel macros'

I have 2 radio buttons: optionbutton1 and optionbutton2 and two comboboxes: Combobox1 and Combobox2.If i select 1st radio button 2nd combobox should be disabled.Vise versa

View 9 Replies View Related

Radio Buttons To Behave Similar To The Forms Version Of The Button

Dec 17, 2009

I'm trying to create a form using radio buttons from the "Forms Tool Bar" and not sure I shouldn't be using the "Control Tool Bar"

I've got multiple buttons and wanted to group them so i used the "Group Box" from the Forms tool bar but now there's a box around the buttons (I've turned off Printing for the box) that gets in the way of other text on sheet. I did some searching and thought I read where you could also use the drawing tool bar and draw a rectangle around the buttons which would then let them operate independent of other groups of buttons but that doesn't seem to work so I'm guessing I imagined it. I also noticed that if you don't draw the "Group Box" around the hole radio button box, they don't work with others in the same "Group Box"

I'm not sure if I should use the buttons in the "Control Tool Bar" but I'm thinking I should so that I have the flexibility should I decide to do something different in the future. I'm thinking about using the buttons to hide a sheet as well as select the sheet for printing, but for now one hurdle at a time.

Lastly I tried looking up some information on how to get the "Control Tool Bar" radio button to behave similar to the "Forms" version of the button (i.e. click the button and it appears to alternate from other buttons in the group), however when I place my mouse over the button it selects it rather than letting me change it's state from true to false.

View 8 Replies View Related

Excel 2003 :: VBA Radio Button Reverts To Default State

Mar 13, 2014

I have an excel file containing 50 sheets which we use as an accreditation test. Each sheet contains one question to which there are several possible answers. These answers (for example, A, B, C and D) are option buttons and when a user selects one, that selection is recorded as their response which is then marked. After answering a question they click a NEXT button to move on and as they move on the previous sheet (question) is hidden so they only ever see the current question sheet.

This has worked well for us for a few years, but we have just noticed some odd behaviour on ONE SPECIFIC sheet. The option button the user selects on that sheet (it is actually question 13 in the sequence) is not stored after the test is completed. However on every other sheet, the selection is stored fine - just this one sheet. The properties of all objects on the rouge sheet are the same as the other sheets. I have duplicated a working sheet and tried replacing the question 13 sheet to try that, but the problem persists.

I tried deleting that Q13 sheet and running the test without it and the same problem occured but this time on the preceeding sheet (question 12) which suggests it is not the actual sheet that is causing the problem.

This is the vb code we have on each sheet

Option ExplicitDim Response As StringDim q13 As IntegerPrivate Sub cmdQ13_Click()    q13 = 0
If optq13a.Value = False And optq13b.Value = False And optq13c.Value = False And optq13d.Value = False Then
Response = MsgBox("You must answer Question 13 by selecting one of the options!", 16, "More Information Needed !")        
[Code] .....

So in this example there are 4 option buttons and 1 command button. It is no different to the other 49 sheets

View 2 Replies View Related

Userform Listbox That Lists Data Based On Radio Button Selections

Mar 14, 2009

I have a worksheet (attached) that lists various clients in columan C. Column E lists whether each of the clients listed in Column C are 'Existing Business' or 'New Business'. I require a user form that has three radio buttons (one to select 'New Business', another for 'Existing Business' & one for 'All').

When Selecting a radio button, (e.g. 'Existing Business'), I need all clients listed in Column C of the worksheet that also have 'Existing Business' in Column E to be listed in a ListBox on the UserForm (with the second radio button allowing the text box to list 'New Business' and the third to list both Existing and New).

View 3 Replies View Related

Userform One Combobox Three Data Columns Select Required Column Based On Radio Button

Jun 10, 2013

I have a user form that has one combo box on it that right now references one column of data.

Now I am being asked to have three columns of data and the combo box to show one of the three when a certain criteria is met.

I believe it would be easiest to have an additional combox with a change event when the box is populated with "whatever" in the field

So S:3 to S:5 have A, B, C

And EC:1-EC:59, ED:1-ED:59, EE:1-EE:59 contain the data that should show when S:3, S:4, or S:5 is selected.

If S:3 is selected then the list in EC:1 - EC59 would show and so on.

View 2 Replies View Related

Deleting Form Option Button Groups

Mar 28, 2007

I have developed a 'Work In Progress' (WIP) worksheet containing space for several jobs. Each job has a group of option buttons in it which are NOT acting as triggers or code dependent (just for selection purposes).

Users are able to delete the entire job (12 rows) but the option buttons just move 'up'. I know how to delete these items by use of code if I could determine their name. But - can I programmatically determine the group name for the specific job/range that is going to be deleted.

Worksheet automatically is protected - there is no password.

View 6 Replies View Related

Swap Out Text In Text Box Based On Radio Button Selection

Dec 12, 2012

If the user selects French (radio button selection), I want to swap out the existing English text for French and vice versa. One large text box with several paragraphs. Can Excel do this?

View 2 Replies View Related

Moving Row When Column Reads (Yes) And Button Is Pressed

Mar 13, 2014

I have a situation with a spreadsheet i'm working on.

Basically, when a button is pressed I want it to search for all rows which have a "yes" in an offload column (Column AS, on the sheet "Active") (So it can be yes or no).

If it finds a yes, I need it to move the whole row in to a new sheet called "inactive", then move the remaining results up.

I have taken and played about with a different VBA code, but i'm not sure it's even the right line!

Here is what I have :

Sub Refresh() ByVal Target As Range)
If Target.Column = 45 Then
If UCase(Target.Value) = "Yes" Then
Target.EntireRow.Copy Destination:=Sheets("Inactive"). _
Range("A" & Rows.Count).End(xlUp).Offset(1)
Target.EntireRow.Delete
End If
End If
End Sub

View 9 Replies View Related

Command Button Moving After Macro Runs

Jan 25, 2008

My command buttons are moving location after I run a macro. I have a worksheet with 5 command buttons from the forms toolbar. When the macro is run, another command button is moved into the cell that the macro ends in, how can I stop this?

View 7 Replies View Related

Moving And Deleting Entire Rows Between Tabs In Workbook And Moving Them Back If Needed

Sep 23, 2013

I have an excel work book with 6 tabs. I would like to have Excel move an entire row from one tab to another tab (removing the row and inserting it in the other tab). I.e. Example I have a tab with items that are marked as "Open Actions" so if I were to change the drop down to close. Excel would move that entire row of actions to the tab with the "closed actions" and insert into the next available row. Now if someone were to come back at a later date say no it should be reopened than I would change the drop down to open and excel would move that row back to the open actions tab into next available row. I tried a PIVOT table and no good I played with few macro and not.

View 5 Replies View Related

Radio Buttons.?

Apr 8, 2009

I've got a small problem with radio buttons. I've been asked to add a few to a sheet we use at work, problem I'm having is when I add these new buttons from the forms toolbar and then assign the cell link for them some of the other radio buttons on the sheet asume the cell link of the new buttons and when I change them back the cell link for the new buttons change ? i could understand this problem if I had maybe copied them and modified the copies perhaps but that isn't the case.

View 2 Replies View Related

Ensure A Negative Or Positive Value

Feb 2, 2010

My form has a combobox with three options "Withdrawal" "Deposit" "Fee". I want to make sure that whatever number a user puts into a textbox, if they select "Withdrawal" or "Fee" that number will be converted to a negative number, and if they select "Deposit" it will be positive. I have written the following code and am just wondering if there is some super slick way of doing it other than an if statement.

View 2 Replies View Related

Ensure Data Integrity

Jul 15, 2006

I am trying to ensure that only alpha numeric data (one letter then 4 digits) is entered in a cell.

View 9 Replies View Related

Ensure Cell Cannot Contain A Certain Character

Oct 18, 2007

I enter for example in a cell : 0625-C0/01
sometime 0 is entered as O a letter and not zero.Is there a way to ensure that only 0 (zero) is allowed in that string using data validation rules.

View 6 Replies View Related

Ensure TextBox Entries Add To 100%

Dec 10, 2007

I have five text boxes on a user form. I would like the 5th box to always equal 100 - the Sum of the other boxes, and never go below 0.

In other words, the text boxes are representing percentage breakdowns - so to validate the percentage entry in each box i want the last box to 'count down' from 100 as the percentages are distributed amoungst the other boxes. This box will also be a percentage figure, so is crucial it has its own box (rather than just saying these four boxes have to total 100) i hope this makes sense!

I have tried a code along these lines (see below) - (adapted from this forum but couldnt get it to work) I also found a version where one poster used a command to change the 'value' from string to numbers - but have been unable to find that again.

Private Sub txtbox1.change()
txtbox5 = 100 - (CCur(txtbox1) + CCur(txtbox2) + CCur(txtbox3) + CCur(txtbox4))
End Sub

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved