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


ADVERTISEMENT

Make Check Boxes Behave As Option Buttons

Oct 27, 2009

I have a form with at about 1200 checkboxes and I need to make them behave as radio buttons. What I mean is that just one box can be selected in a group of boxes.

Lets say i want to group all 1200 boxes in 400 groups, with 3 check boxes in every group. I want user to be able to select just one check box in every group.

View 12 Replies View Related

Multiple Macro Buttons (radio Buttons)?

Feb 10, 2012

I am trying to create a worksheet that has multiple radio buttons. Each radio button is linked to a Macro. I need there to be many buttons running down one side of the worksheet. Each button needs to perform a macro that is relevant to the cells in the same row that it is on.

Essentially what i am trying to do is make a macro that when the button is pressed copys data from H6 and paste it into B6. The button is situated above I6. I need a button for each row from 6 to 110.

While this macro is easy to create (i use the record button and then assign the macro to the button), i would have to do this 104 times and assign a new macro to each button.

Is there a quicker way?

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

Radio Buttons Reset

May 5, 2008

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

Action From Radio Buttons

Feb 16, 2007

What 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

View 9 Replies View Related

Can't Delete Text Box Or Radio Buttons?

Feb 22, 2013

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 Related

Resetting All Radio Buttons Within Worksheet

Feb 25, 2013

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

Autofilter Based On Radio Buttons?

Feb 18, 2014

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

Cannot Delete Textbox Or Radio Buttons

Feb 22, 2013

I 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

Radio Buttons In Protected Sheet

Aug 6, 2008

I have a pair of radio buttons on an Excel 2007 sheet. I want the buttons to be clickable, but have the sheet protected.

Both are defined as unlocked. The Group containing the two buttons is also defined as unlocked.
But when I protect the sheet, one of the two buttons gets the pop-up saying the cell is protected - the other button is fine. I've even tried unlocking the cells behind the buttons, but it still pops up.

View 9 Replies View Related

Selecting Radio Buttons Using A Macro

Oct 20, 2008

I created two radio buttons on a spreadsheet where a user can select
one button for Yes and the other for No. When I right click these
buttons, I notice the names (shown on the left hand side of the
formula bar) are:

Option Button 3 (for No)
Option Button 4 (for Yes)

I'd like to create a macro that automatically selects the Yes or No
button depending on a cell value in another tab. If the cell value is
1, the macro should select Yes. If the value is 0 the macro should
select No.

I tried running the macro below:

Sub testSelectYesOrNo()
If Not IsEmpty(Sheets("Sheet2").Range("A1").Value) Then
Select Case Sheets("Sheet2").Range("A1").Value
Case Is = 1
Sheets("Sheet1").OptionButton4 = True
Case Is = 0
Sheets("Sheet1").OptionButton3 = True
End Select
End If
End Sub

But when this runs I get a "Run-time error 438 Object doesn't support this property or method"

When I click debug, the text "Sheets("Sheet1").OptionButton4 = True"
was highlighted.

View 9 Replies View Related

Excel - Adding Radio Buttons / Checkboxes

Apr 3, 2014

I was viewing this thread here: [URL] ...

How to add checkboxes and radio buttons.

View 8 Replies View Related

Using VBA To Link Radio Buttons To Display An Observation

Dec 15, 2008

I work in the science field and I'm trying to record an observation with some codes within a template. I have 5 different codes (A-E) to choose from and want to display the code that the person has chosen for each of the 6 compounds they are working with.

I started creating these command radio buttons with some code to display the results in part particular cell, but I would need to do this 30 times linking each group together to get what I want. I know there's an easier way to do this but ....

View 6 Replies View Related

Using Enter To Select Radio Buttons Or Checkboxes?

Feb 14, 2012

just wondering if there's a way i can make the Radio buttons and check-boxes in my forms select-able by hitting enter? My form is quite long and it takes too much time for users to always have to grab the mouse and click the box, if they could just tab to the radio box or check box and hit enter to select it it would be awesome!

View 2 Replies View Related

Group Radio Buttons & Link To Cells

Jul 31, 2007

I am trying to make a basic worksheet that will have radio buttons. I have searched around for about 2 hours and can not find any documentation on how exactly to create a buttons and make it do what I want. I have also tried F1 in Excel but that hasn't helped any either. I did stumble uppon a file called "Options.xls" when searching this forum but it does not explain how the buttons were made. The only thing i can figure out how to do is basically insert a button onto the document, and rename the label of the button that's about it. I basically want to create a group of (3) or so buttons. If button A is picked, cell D1 will display "x". If button B is picked, cell D1 will display "y", and so on. Is there a link to an example out there that shows how to create and use buttons?

View 2 Replies View Related

Checkbox Or Radio Buttons That Make Other Cells Appear Or Disappear?

Jun 17, 2014

by using radio buttons or checkbox, or anything similar. Based on the answer, I would like cells to appear below the question, for example in B3 another question would be "how many guests would you like to invite?" and B2 would be their answer but is preset to "0"

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

Pivot Table With Tick Boxes And Radio Buttons

Oct 18, 2006

every week i send out a pivot table to different project co-ordinators and would like a way of having simple option button so that they can have the data by "hours" or "costs" and can use tick boxes for the row fields they want to show, for example, "profession", "workstage"," name","cost rate". The page field will always be "Project" and the Column Field will always be "Period" and " Date"

I then want the pivot table to change automatically to their choices. I am pretty basic with VBA so may need explanantions too. It would save me sending out 10 versions of a pivot table all feeding off the same data! They could actually do something themselves! (i know they could drag the fileds they want into the areas they need them but trust me when i say they are not that advanced, they are good at ticking!!)

View 2 Replies View Related

Buttons Code For Forms

Nov 15, 2008

I've been creating forms/questionnaires, customer satisfaction type tings with Excel after I discovered that the previous ones were done on paper and itís now my job to crunch the numbers for a report.

While I've been off learning how to do this in a suitable way for the office I work at, I've been neglecting the stack of papers from previous customer satisfaction surveys that are building up on my desk, about 200

So now rather than do what I think everyone else would do and make up the numbers. I thought I would just make a excel book with buttons for all the possible options on the survey and click them as I look through the papers.

So I need to learn how to make a button that, when clicked it would add a number to a cell. So if I clicked it 10 times, that cell would show 10.

so I can make the form with the buttons, what code/formula will I need to assign to the button to make it +1 to say, sheet2 A1?

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

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







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