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


ADVERTISEMENT

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

Pivot Table Reverts To Earlier State When Clicking Refresh?

Feb 5, 2014

when I refresh data in a pivot table. Each time I click 'Refresh All' it alternates between a refreshed version (up to date with source) to an earlier set of data. This is concerning because operators will not be aware that they are not using the most up to date data 50% of the time.

View 3 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

Default State For UserForm CheckBox Controls

Jun 14, 2008

I am having a little bit of difficulty find ways to effectively incorporate a checkbox panel into a form interface. What I am trying to do is all the user to select using checkboxes which of 31 separate columns will automatically be deleted or not deleted. The method I have been using is to create 31 checkboxes, and then use the value of the checkbox (true/false) to determine a value in an array, which then can be used to delete the column by a separate sub.

However, I am interested in being able to have the checkboxes start checked or start unchecked by values contained in a different array. My problem is that I am unable to reference the checkbox itself until the form containing the checkbox is opened, but at that point I don't know of a way to cause the desired checkboxes to automatically be selected without placing a command button that must be pressed to fill them in. Essentially I want to be able to open a userform that has checkboxes preselected.

View 5 Replies View Related

Excel 2010 :: Disable Default Close Button In Workbook

Jun 3, 2014

How to disable the default close button in a workbook not to affect in my command button close.

I tried already cancel = true but my command button close is also been canceled.

View 3 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 its a little more cumbersome then I was hoping. Is there a better solution?

View 9 Replies View Related

Excel 2003 :: For Every Button Click - Run Few Set Of Statements?

Feb 26, 2014

I have button on the first tab in excel 2003. On every click of button, I need to loop the data.

View 4 Replies View Related

Excel 2003 :: No Button (To Allocate A Macro To)

Nov 1, 2011

Excel 2003

I have a macro and want to allocate it to a "button" . The macro is all ok.

So I make visible the FORMS floating toolbar / icon set.

There are 16 icons on this floating toolbar / icon set.

But the icon for button is missing, in that it is just 100% blank.

The other 15 icons are all ok, such as "Group Box".

Normally I would click this "button" icon, then draw my button, then allocate my macro to it.

View 2 Replies View Related

Excel 2003 :: Button To Sort Rows?

Feb 20, 2013

Running excel 2003 and have a number of sheets where i want buttons along the headings to sort a selection of rows.

For Eaxample one sheet i have data in range A6:AD135. i would like to assign a macro to various buttons on row 5 to sort by that column ie button in column b sorts all data in the range by column B.

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

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

Excel 2003 :: Attaching Hyperlink To Command Button?

Dec 3, 2006

I am trying to attach a hyperlink to a command button in excel 2003. I open the control toolbox, select command button and place it on the worksheet. with the button selected and in design mode I click on the hyperlink button on the toolbar and allocate the hypelink address. Click on the button and it works fine untill I exit design mode then the button stops working.

View 8 Replies View Related

Excel 2003 :: Shared Workbook - Add Button To Worksheet

Aug 1, 2014

I've added some code the adds a button to a worksheet

Public Sub AddSheetPrintButton()
Dim btn As Button
Dim t As Range
Set t = ActiveSheet.Range(Cells(1, 6), Cells(1, 7)) ' button position
Set btn = ActiveSheet.Buttons.Add(t.Left, t.Top, t.Width, t.Height)
With btn
.OnAction = "sheetPrint"
.Caption = "Print Sheet"
.Name = "Print"
.Font.ColorIndex = 10
End With
End Sub

This works fine until the workbook is shared!

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

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 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

Excel 2003 :: Userform - Ok Button To Delete Data When Clicked On In Combobox

May 8, 2012

I have a userform that has a combobox in it that also has an OK button and a Cancel Button. Need getting the combobox to pull in the correct list? The data for this list will be in cells A2 through A16. But not all 15 lines will always have data in them so I'd like to only show the ones with data. Then next issue i have is I would like the OK button on this userform to actually erase the data the user has clikced on in the combobox. It's a list of kids that the userform is asking which one needs to be deleted. So it might be the kid in cell A9. so when the user clicks on that kid in the combobox form a9 and hits ok I'd like to have all the kids below A9 move up one row.

Windows XP
excel 2003

View 6 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

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

Macro To Prompt Then Record Data Following Button State Change

May 10, 2007

I am looking to find a way and synthesize code that will prompt the user for text data when he/she clicks a radio button, then place that text data in a "Notes" worksheet within the same workbook. Given that there are multiple radio buttons, with options of "OK" and "attention needed" (it is a checklist of maintenance items), I also need to find a way to have each note listed sequentially in the notes worksheet. My questions: Is this possible using macros? Can you steer me in the right direction? (change event, inputbox, then what?)

View 3 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

Returning State Cities By Inputting Given State Abbreviation

Jun 3, 2012

I'm trying to create an array formula that returns all the cities in a given state by imputing the state's abb in cell K2. The returned cities go into column J. California has the most cities(430) and the cities are 5000 rows deep.

View 7 Replies View Related







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