Option Group Box
Jan 24, 2007If you have 5 option boxes in the group at the top of a form and want to make sure the user of the form selects at least one box before continuing on, how do you do that?
View 9 Replies
ADVERTISEMENT
Use The Group Box To Group A Number Of Option Buttons Together?
Jan 17, 2013how to use the group box to group a number of option buttons together.
Question is, lets say, i have a total of 4 group box. if i want it to work in such a way where by once 2 option buttons are being selected (1 option selected from each group box), the rest of the option buttons in the 4 group box will be greyed out. is that possible?
Option Button Group Value
May 14, 2013I have user form with 5 OptionButtons in one group called Group1 and another 5 in Group2.
I need that those 5 OB in each group had value from 1 to 5 and then user selects one OB it will inset that value (not TRUE or FALSE) into cell and same with Group2.
Private Sub CommandButton1_Click()
Cells(ActiveCell.Row, "E").Value = Need value of Group1
Cells(ActiveCell.Row, "D").Value = Need value of Group2
End Sub
Linking Option Buttons In Different Group Boxes
Jul 2, 2009I have a form that contains a group box with option buttons, and for clarity's sake, next to it another group box, also with option buttons. So, I can choose 1 option in one box and another option in the other box at the same time. I'm sure you heard me coming a mile away, but here it goes anyway: how can I link the two group boxes (and option buttons) so I would only be able to choose 1 option out of both boxes?
View 4 Replies View RelatedCheck If One Of The Option Button Value In Each Group Is True
Mar 1, 2009I have a 90 optionbuttons on a sheet in groups of three. I need to check to see if one of the option button value in each group is true.
View 9 Replies View RelatedDetermine Right Or Wrong Answer From Option Button Group
Jan 1, 2008I am working on creating an examination questions in Excel. I want to also build in formulas in the Excel sheet so that the answers will be calculated automatically as the candidates choose the answers. I have inputed an option button from the froms toolbox beside each answers for the candidate to click to indicate the answers. Is it possible to calculate the correct answer or wrong answer with a formula when the candidate clicks on the option button ? Is there a formula that I can use?
View 2 Replies View RelatedMaking Sure An Option Button Has Been Selected Within A Group Before Exiting Survey
Nov 26, 2009I have a survey with different groups of Control Toolbox options buttons on it. I want to ensure that each question has an option button selected before the survey can be exited and emailed onwards. The grouped button names are: GroupA, Group1 through to Group6.
View 2 Replies View RelatedExcel 2013 :: CF With 2 Option Buttons / Multiple Option Groups?
Sep 6, 2013I have several option groups (Y & N in each) linked to cells to display TRUE / FALSE depending on which option is selected in each group. I have another cell which I want to apply conditional formatting to if EITHER Y or N is selected in all groups. At present I use COUNTIF to check for FALSE=0 in the linked cells which works if all the answers are Y. How do I apply CF if there is a mixture of Y & N (TRUE / FALSE) in all groups (I'm not sure if I've explained that well or not).
Excel 2013
VBA To Search Group Of Cells And Input Message If Value Is Missing From Group?
Mar 17, 2014I am trying to write VBA code that groups cells between blank rows and inserts a message if a string of text (a name) is missing from the entire group. I want the code to search cells in column A and group the cells between blank cells. Use the name I input in an input box as the search criteria and insert a message in the Column C next to the last blank cell in the group and then move on to the next group and highlight the cell in red with bold text. I am including a spreadsheet with an example of what the sheet should look like before and after the code is run.
View 11 Replies View RelatedPivot Table Group :: Group By Integers And Not By Months, Years Etc?
Nov 12, 2009I have date fields as column labels in a pivot table. When I try to group them I'm only given the option to group by integers and not by months, years etc.
I've had a look at the format settings of the column and they are formatted as date fields.
Insert Group Header Based On Consistent Value Within The Group?
Feb 10, 2014I have several groups of data in the same sheet. Each group has two blank rows above the first row of data. Each group has column "B" in common (e.g., "Phone" in the example attached). I'd like to add a title/label of "Phone" to the first column in the row immediately preceding the first row of data for that group.
View 1 Replies View RelatedConvert A Group Of Numbers To A Group Of Letters
Aug 9, 2006My store uses a retail price "code" wherein a price like 99 in expressed as a
code like "PP"--exchanging the number digits 1-0 as letters.
Is there a function to do this automatically?
Apply Row Count Of Sub Group In Each Row Of Sub Group
May 28, 2014In Col X of the attachment, I have manually entered the count of the rows within each sub group, as determined by the counter in Col W. How can I do this automatically? I need this because when I filter the spread sheet by Rank, I need to know how many selections, of the filter Rank query, were in a sub group of ? number.
View 2 Replies View RelatedSort And Group Names Then Sum Associated Numerical Values For Each Group - Sort Total
Apr 18, 2014I have this massive spreadsheet, with the maximum rows excel will fit on one sheet. In the interest of simplicity, this is what the raw data looks like:
Last First Amount
Jones Jim $1000
Jung Joe $700
White Jon $100
Jones Jim $200
Jones Jan $300
Jung Joe $800
White Jon $200
What I want to do is automatically get excel to group all the same names together. Then I want it to sum all the values for each name, then order by largest total value for each person, then order that by name alphabetically. In other words, the above would look like this after the sort:
Last First Amount
Jung Joe $800
Jung Joe $700
Jones Jim $1000
Jones Jim $200
Jones Jan $300
White Jon $200
White Jon $100
Or, if necessary, there could be sum total rows under each name...although I don't have spare rows, so IDK. I could delete some rows if I had to, but would rather not.
Change Color Of Group Of Cells Based On Data In Another Group Of Cells
Jan 12, 2014Conditional formatting. I want to change the color of a group of cells based on data in another group of cells. Example:
If cells G8 and G9 (which are merged) are between 80% and 94%, then I9,I10,I11 (which are merged) will turn Yellow. Also, under the same scenario, IF G8 and G9 is greater than 94%, then cells I9, I10, I11 will turn Red.
Multi Option Sum
Jan 8, 2010I want to sum data in COLUMN C that is related to COLUMN B if the COLUMN F is blank.
View 10 Replies View RelatedAdding A New Option?
Feb 16, 2014I have the following formula =IF((F3=1)*(H3=1)*AND(J3=1),1,0) and I do need to add the option C1 besides 1 so it would be something like this...
=IF((F3=1orC1)*(H3=1orC1)*AND(J3=1orC1),1,0)
Right Click Option
Jun 7, 2009I lost my right click option in excel, all I get is a little gray box that does nothing. I know it is something I did today, it has worked perfect before. Has anyone seen this happen, the problem is only in excell 2003.
View 2 Replies View RelatedSet An Option Button By Name
Oct 8, 2009In Excel 2003 VBA, what is the syntax for controling an Option Button or Checkbox by name or caption
I have tried the following but has an error, I am sure this is a simple one.
VBA / Msgbox With No Yes And No Option
Jul 21, 2012I am trying to have a msgbox come up if there is a path found it will pop up a msgbox for a few seconds then go away. Im trying to avoid the user from having to select anything just simpley telling them the connection is there then go away on its on. The code below is what Im currently using.
Code:
If Dir("H:") = "" Then
MsgBox "Error: Drive, path or file not found"
Else
MsgBox "OK: Drive, path or file found"
End If
Option Buttons
Aug 23, 2007I created a frame in a spreadsheet I put in 2 options buttons that I called Left the first one and Right the second one. I got 2 cells lets say C10 and G10 in these 2 cells I write the cell number values. When I click on button one or Left, I need the cell C10 be set focussed and write a number e.j 5. However, when click on the second butt to write a number e.j 7, the number in the cell C10 still there, so, what I need is a cero or an empty cell C10, and viceversa. Could you help to write a code for this problem.
View 9 Replies View RelatedWhat Does Option Explicit Actually Do
Aug 30, 2008i've used this a few times at the top of various modules, as suggested by various knowledgable people on here, but it might be a good idea to find out what it means, and what it actually does!
View 9 Replies View RelatedParamArray Option
Nov 28, 2008My purpose is:
1) I have a macro workbook with multiple procedures (6 main tasks)
2) Some workbooks will use all procedures, and some will not use all procedures (most use either 4 or 6 of the procedures)
3) To hide the unwanted procedures as required, the menus will not appear for those choices (in code that creates custom toolbars on activate)
Solution (proposed):
1) send a paramarray argument with string elements that identify menus to use
2) send a “show all” true or false, to simplify identification of workbooks that use all procedures
Reason solution is chosen:
1) I can basically have one macro workbook this way – so simple implementation even where some workbooks won’t need all the macros (and should definitely not be making them menu options).
2) If I add more routines, I can just extend the ParamArray as needed and continue to identify specific toolbar options to use or not use.
Problem:
1) That paramarray is interesting! It can’t be passed and its initialized as an array with bounds 0 to -1. Also, it can’t be tested directly to see if its Empty. So I came up with checking for the -1 UBound, combined with loading the elements into another array (seems stilted to me).
I’m not sure what I’m asking, but…I need to determine if the paramarray is being used, and be able to pass it. Is there a simple way to do that? As I’m sitting here writing I’m realizing I could just pass a regular array and dispense with the ParamArray option -- well, I’ll post my thoughts anyway. Sorry this is so rambling…
Here’s the code I’m using (basically). Note that DoSomething actually checks each element of the array to see if it matches a potential menu item (by name), and if so, marks that menu item to be added - since there's 6 menu options, I placed it in a separate method to avoid have it in the routine 6 times.
Maybe I'm just curious if anyone ever successfully uses the ParamArray option - it seems to me to be somewhat of a bother that you can't easily tell if it's been passed in or not, or use it like a regular array (check if its empty, etc.).
Sub MyToolbar(ByVal blnShowAll, ParamArray args() As Variant)
Dim a() As Variant
Dim x As Variant
How Do I Make A Msg Box With Out Any Option
Dec 29, 2009I made a msg box but i dont want any option to be displayed in it.. it only should display as an info to the user.
View 9 Replies View RelatedOption Explicit ....
Feb 18, 2007I have some VB code "For, next" that I have written with numerous variables. All the data appears to be totaling correctly. After reading some comments on this site I added Option Explicit to the top. Well, it stops on my first For Each Cell, with cell highlighted and an error message 'variable not defined'. I have searched and searched and can't find what it might be. Does this error message mean I am getting incorrect results? Is there an easy way to determine which variable is not assigned? A function key or something?
View 9 Replies View RelatedTwo Option InputBox
Mar 22, 2007I am trying to simply the data input for someone who is not very experienced.
I have had some success but need to have an extra option in case of mistakes.
Ideally I need the following -
I want an inputbox that will appear when the user starts the macro and for example asks Enter Surname
Then I know what I want but I don't know how to do it.
I want a box to display the Surname that the user typed into the inputbox with a message asking Are Details Correct? with a Yes and No Button.
Clicking the Yes button moves onto the next inputbox clicking the No button cancels the whole macro before it enters data into cells.
Option Explicit
May 3, 2007I work on a worksheet that has 10,000 rows all in column A with members that have 353 different plans.
Here is an example:
Robert
James
Ted
Ronald
This is for plan 426-0
Amanda
Nikki
This is the total for plan 426-7000
I need to move the plan type for each member to column c. When moving the plan type I only want the number have the dash. For Robert/James/Ted in column C the plan type is 0. For Amanda and Nikki in column C the plan type is 7000. I have created a macro that can move the plan over but not the number after the dash.
Here is what I have come up with so far.
Option Explicit
Option Compare Text
Sub R007()
Dim i As Long
Dim sPlan As String
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
If Left(Cells(i, 1), 5) = "Plan " Then
sPlan = Cells(i, 1)
Rows(i).Delete
Else
Cells(i, 3) = sPlan
End If
Next
End Sub
Set All Option Buttons To No
Jun 26, 2007is there a way to set all yes/no option butons to "no" when a worksheet is activated?
View 5 Replies View RelatedAdding A Second Option To COUNTIFS?
Dec 26, 2013I have a COUNTIFS function that, among other criteria, only counts cells in which the value is "P". I now want to modify this function to count cells in which the value is "LA" in addition to cells in which the value is "P". I'm not sure how to work this into the argument. I tried using OR("P","LA"), but that's not working.
View 3 Replies View RelatedOption Button Grouping
Dec 10, 2013I'm trying to replace a bunch of checkboxes on a sheet with a bunch of Form Control Option Buttons. The problem I'm having is every option button I add seems to be grouped with all of the rest of my option buttons. If I add buttons 1 & 2, I need those 2 grouped together, and when I add 3 & 4, I need those grouped together. Currently it's grouping all 4 buttons together so 1 - 4 are linked, but I need 1 & 2 linked together, and 3 & 4 linked together. I've tried grouping, but it still doesn't function how it ought to.
View 13 Replies View Related