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
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?
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
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 RelatedI 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.
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 RelatedI 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?
VBA code for go to next sheet using radio button.
View 1 Replies View RelatedWithin 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 RelatedI 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).
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.
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 RelatedI 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.
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
I just discovered VBA coding today and was wondering if I could use it as an audio alert. I found a couple examples online but don’t understand the coding language of excel. I have a feed link from my trading platform to excel that feeds in live data. What I would like to do is have an alert for when Range ("C4").select is >=1000 Alert Ring.wav and when Range ("C4").select is <=-1000 Alert Chimes.wav.
View 5 Replies View RelatedI'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.
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] ......
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
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).
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.
Each month I get a report that I process using a macro. The problem is that each month the name of the file changes and is different. When I run the macro and it crashes I have to de-bug by going through the code to change all references to the file name from the the previos run and change to the latest file name and then re-run the macro. There must be a better way.
I would like to learn the code that sees the open book and then refers to it for the run.
What is the best way to do this?
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 RelatedI have 5 columns with an auto filter applied using the code below. I also have a form button in each column to reset the filter. What I would like is to have the form button turn "red' when the filter is applied and return to the orginal color when the filter is removed.
If it takes something other than a "form" button that is fine. I am looking for 2 "buttons" one to apply the filter, the other to alert you that the filter has been applied and to reset the filter when clicked.
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 RelatedI am having around 80 - 90 radio buttons in my excel page for filling up the forms, but each time i need to give this to a new user i have to reset all the buttons manually, is there any way where in i can do this in one go and all the radio buttons are reset at once without me doing this manually.
View 9 Replies View RelatedWhat code do I need to have behind a command button to carry out an action (for example select cell A1 or B1) depending on which one of two radio buttons are selected? I have tried:
Sub Button23_Click()
If Opt1 Then
Range("A1").Select
End If
End Sub
I have inherited a spreadsheet that has a text box and a radio form that I cannot delete for the life of me. I can't click to select either one nor right click to do anything. I have an "Approve" and "Reject" button on top of them and those work great. But how do I delete the others?
View 1 Replies View RelatedI am creating scorecards for our company and ratings are inputted using radio buttons (form control). I have a "clear" macro that clears all fields and radio button values (none is ticket). This macro is called throughout different sheets, as different roles in the company have different KPIs and should be on different sheets. I need a code that detects all radio buttons within a certain sheet and clear their values. I cannot put specific radio button names, as I have a lot.
View 2 Replies View RelatedI need to filter data from row 87 downwards depending on the choices above. Some of the choices could be only one like in the measurement type. That I can take care of but what if the choice is more than one, it could be four and it is not fixed. Is that possible in autofilter? This is when they go to checkboxes where they may have many option. The mounting part is best example of many options. This is the part I can't incorporate to macro. It's somoething dynamic. I can't make my filter autoadjust. So essentially,I wanted to automatically edit the filtering based on those 10 criteria, which is also in ten different columns.Sample work.xlsm
View 1 Replies View RelatedI have inherited a spreadsheet that has a text box and a radio form that I cannot delete. I can't click to select either one nor right click to do anything. I have an "Approve" and "Reject" button on top of them and those work great. But how do I delete the text box and reject radio button?
View 2 Replies View Related
