I have up to 6 checkboxes on a work sheet but I only want one of them to be allowed to be checked at any given time. Is there a way to make sure this happens? As an example if the first check box is marked and then the user checks Checkbox4 checkbox1 would automatically be unmarked.
View 6 RepliesI have a spreadsheet that consists for 30 rows of groups of three checkboxes on each row. I want to have only one checkbox per row checked at a time. If the user checks one box while another it already checked then I want that checbox to be unchecked.
I want checkboxes to work like groups of option buttons. Actually, option buttons would be fine but with option buttons there is always one clicked but I need them all clear until the user clicks one. They will start off clear but if the user clicks one by mistake there is no way that I know of to clear it again. Checkboxes will clear again if you click it again so I thought I would use them.
how to have a group of three option buttons or checkboxes that will begin unchecked and be able to uncheck all three is one is checked in error,
married, widows, single checkbox is selected
macro solution
good work.
Is there a way to have a data validation drop down menu but at the same time allowing users to enter free text as well.
View 3 Replies View RelatedI have a spreadsheet that I use for people to make requests.
They can only select from the dropdown menus or the check boxes in the spreadsheet. Some fields are required.
I have a button that they click on to save the workbook.
When they click on it a macro checks if all required fields are completed. If they aren't, The user receives a Message box asking them to complete all required fields.
The problem I'm having is with 5 checkboxes each linked to a cell (B11:B15).
The user can check any or all of the boxes but they need to select at least one.
how I can check if the user selected at least one and if not then I would display a Message box asking them to select at least one?
Here is my code ...
In an Excel user form, I want to display a checkbox only if the user selects another checkbox.
View 4 Replies View RelatedI have a page that is protected so formulas are not changed mistakenly, and have check boxes on the paged that link to cells and display True of False based on the checking of the box or not. If I leave the page unprotected I risk the True or False being changed. Is there a lay to protect those cell from the user but still change when the box is checked or not. The checkboxes are Form Control type.
View 6 Replies View RelatedI would like to ask regarding checkbox checking. I have 1 master checkbox and 3 sub checkboxes on the userform, and my target is that if the master checkbox is selected then I want to receive a msg if one of 3 checkbox are not selected when I hit the "Confirm" commandbutton.
View 3 Replies View RelatedI was asked about if i can copy defined cells when i checked its checkbox by using vba button , and another button in another book to paste those cells .
Mention that i may select more than one checkbox in copying and when i would paste these checkboxes , they would be in queue.
I have a workbook containing several sheets, each sheet has a large number of ActiveX check box controls on it.
The controls are presented in groups of three to capture responses to a question (Y/N/NA). If one of the three check boxes is set to True, the other two associated check boxes must be set to False.
What I want to do is avoid having to have an On_Click event sub for every single check box.
I have written a function that will handle updating the related check boxes but I am unsure how to call this function, passing it the name of the clicked Check Box whenever any check box is clicked.
Here is my current code with an On_Click event being used to call the function:
Private Sub chk100_01Y_Click()
' Want to replace this with a dynamic sub that will be invoked
' when any Check Box is clicked and pass the name of that Check
' box to the function
Call Update(ActiveSheet.OLEObjects("chk100_01Y"))
End Sub
I currently have a user form and am trying to make a counter to that will increment if the check box is not selected, but will not increment if the check box is selected.
I am assuming I could use an if then statement for this, under the command_click OK. but I cant get it to work.
Im looking for a macro that can get a cell RANGE, the data in the RANGE will be copied then if the checkbox is selected it will copy the same data in the RANGE and add the selected checkbox in next column
I have column A and Column B < this is my selected range
Capture1.PNG
I will have a form that has checkbox and buton.
When all the checkbox is selected. when the button is click. the result will be.
how to reference cells in 1 page from another and understand basic formula's, and would appreciate any input on how or if i can acheive what i'm trying to accomplish.
I have a worksheet with say 100 rows of information, it is a list of materials to go into a construction job. the columns to the right of the description calculate volume/quantity etc and produce a cost for the item. what i want to do is have a summary page that only lists the items that are being used, not all 100 items are in every job and i dont want to have to print the whole list with a bunch of empty values, which will just waste paper and ink. I'd like to enter a value in a cell or setup a check box or something that i could somehow use to then list that row or a part of that row of information on a seperate sheet, for a nice concise, easy to read list of job materials. i would like to do produce 1 sheet with the cost associated with the item, and one without cost.
On the attached Dynamic chart I have attached there are 3 checkboxes to display certain data. My issue is this, if I click the outside checkbox and the ISE checkbox at the same time that is OK, it gives me a comparison of the two data sets in a bar chart. Perfect. If I click just the total checkbox it gives me the total info of the outside and ISE, again perfect.
But, If I click all 3, it doubles all the numbers because total is total and outside + ISE also equals the total.
My Question,
-Is there a way to lock out a checkbox if another is active?
if 1 then no 2 or 3. if 2, 3 is OK but 1 is not. if 3 then 2 is ok but 1 is not?
-If it can't be locked can it do something like; If #1 has a check and you try to enter #2 a red error message could come up saying these two choices together the data will be inaccurate. I'm thinking this might be done in conditional formatting.
If option one is doable and easy, is it also possible to have an error message like in my second idea so people will know why they can't click that second box? This would be my preferred fix but I am open to any other option you may have to accomplish this.
I’ve created a worksheet containing many drop down lists that form an inventory of household effects. Once selected, I’d like to be able to view/print the selected options and quantities separately on one A4 page.
I don’t want the separately viewed/ printed page to contain anything other than the selected options. The problem I’m having is to arrange this new page as a contiguous list.
how to include a line of code, to start a sub running at a selected time? Given that the workbook is already opened before that time?
View 6 Replies View RelatedIs it possible to get the current Page Item Selected for a pivot table
I've tried the following functions in VBA, but have had no success
CurrentPageName
CurrentPage
CurrentPageItem
ParentItems
I need a date and time to appear and disappear in the corresponding cells when the checkbox is ticked and unticked. I got it to work but that was before i had multiple checkboxes on one line and added merged cells.
View 2 Replies View RelatedIn my userform I have a list of check box's that can be selected. Currently if more than one is selected, they will appear in the spread sheet in the same line one after another with a space between them. How do I make it so they either appear with a comma appearing after each, so the next value appears on the next line below or most perferably the cell turning to a drop down list with the values?
Current code
VB:
If CheckBox1.Value = True Then ws.Cells(iRow, 2).Value = ws.Cells(iRow, 2).Value & " " & CheckBox1.Caption
If CheckBox2.Value = True Then ws.Cells(iRow, 2).Value = ws.Cells(iRow, 2).Value & " " & CheckBox2.Caption
If CheckBox3.Value = True Then ws.Cells(iRow, 2).Value = ws.Cells(iRow, 2).Value & " " & CheckBox3.Caption
If CheckBox4.Value = True Then ws.Cells(iRow, 2).Value = ws.Cells(iRow, 2).Value & " " & CheckBox4.Caption
If CheckBox5.Value = True Then ws.Cells(iRow, 2).Value = ws.Cells(iRow, 2).Value & " " & CheckBox5.Caption
If CheckBox6.Value = True Then ws.Cells(iRow, 2).Value = ws.Cells(iRow, 2).Value & " " & CheckBox6.Caption
Spreadsheet current cell appearence if all 6 are selected ' Chinnook EH101 Lynx Puma Sea King Fixed Wing'
Required appearence:
Chinnook
EH101
Lynx
Puma
Sea King
Fixed Wing
When I view a sheet under Page Break Preview, it shows the Page numbers in the centre of the Page. While I am aware that it would not print the page number I was wondering if there is an option to remove/hide the page numbers.
View 3 Replies View RelatedI would like to create a menu representing "tasks" where an amount of "time" can be designated per option for my employees to select and fill. I would like this information to then be tallied elsewhere so I can keep track of our efficiency.
So far, I've created a table where a "time" input is nested beside each "task" drop down menu, I would like these inputs to be added up underneath the same category on the budget tab.
For example: If I work Monday, Tuesday and Wednesday doing tiling.. I would like the budget to reflect those accumulated hours (throughout the week) nested under "tiling".
Here's the file, what I'm trying to accomplish [URL] ............
I have 3 checkboxes; when one is checked, a set/range of rows should be visible. Only 1 checkbox should be checked at a time.
If checkbox 18 is already checked, and checkbox 20 is then checked, I want the first checkbox unchecked and the rows for checkbox hidden.
I'm using the following code. It works great as long as I check and uncheck the same box before attempting to check another box. But if Checkbox18 is already checked with its rows showing, and I then check checkbox20, the checkbox20 sub runs and as I step through, it jumps to sub checkbox18.
How can I stop my subs from jumping from one to another?
Code:
Private Sub CheckBox18_Click()
If CheckBox18.Value = True Then
Worksheets("TRF").Rows("36:41").Hidden = False
Worksheets("TRF").Rows("42:64").Hidden = True
Worksheets("TRF").Rows("65:76").Hidden = True
CheckBox19.Value = False
[Code] .........
Attached is a workbook. I have manually highlighted the cells to give idea of what I would like the outcome to be.
Moonah OPS sheet.
In Row 5(Shift times), under the drop down menu in cells B5:J5, there is a range of Shift times.
And for the purpose of this I have selected
B5 as 0800:1621, manually highlighted B11:B27
C5 as 06:00, manually highlighted C7:C24
D5 as 07:00:1521, manually highlighted B11:B27
E5:I55(RDO, REC, SICK, Travel) can remain as manual input if it is to much to work out.
Is it possible or just a pipe dream, to use some method to automatically highlight a range of cells based on the C5:J5 'time'?
If the time is an actual shift time, the colour will be green and dark green writing as default, then we can allocate jobs/training/meetings and manually colour them.
Daysheet DAY MONTH YEAR template - Highlight.xlsx‎
I have a combobox with populated values from a named range. I need the first value to be always selected when the form is opened - is there a way to do this
View 7 Replies View RelatedWhat is the code i need to use to assign a macro to a command button which inserts the current date and time in the selected cell regardless of where that cell is?
View 5 Replies View RelatedI currently have two columns one for each of the following formulas and then another column that's works on the result of the two together but what I want to know is how do I get the two combined?
=COUNTIFS('08-09 Scores'!$C:$C,$B6,'08-09 Scores'!$CB:$CB,">="&$AY$5,'08-09 Scores'!$CB:$CB,"<="&$AZ$5,'08-09 Scores'!$AT:$AT,">"&$BA$5)
=COUNTIFS('08-09 Scores'!$C:$C,$B6,'08-09 Scores'!$CB:$CB,">="&$AY$5,'08-09 Scores'!$CB:$CB,"<="&$AZ$5,'08-09 Scores'!$W:$W,"="&$F$5)
I've put the bits that I want to be "or" in red, The first bits are obviously the same and just the last bit needs to be or.
I am basically trying to find out how many games played by the selected team had the first goal scored after a certain time(the first formula)
or the first goal was scored by the away team(the second formula)
I am an Excel 2007 user.
I have a formula (below) that looks only at records based on specific filtering criteria or conditions; one of those conditions is the month of the year: ('Data Dump'!$Q:$Q,Summary!$A$26). This portion of the formula would change as a month is selected.
Opposed to having to rewrite the formula every time that I want to view a specific month, I want to automate the formula to change the first condition when a user selects a month from Column A. This would be a real time, automatic refiltering and recalculation as the user selects different months from Column A
Current Formula that filters and shows only January records.
=COUNTIFS('Data Dump'!$Q:$Q,Summary!$A$26,'Data Dump'!$D:$D,Summary!$A$2,'Data Dump'!$M:$M,Summary!C$2)
Column A (January is in cell A26)
January
February
March
April
May
June
July
August
September
October
November
December
How can i hide and unhide one checkbox using another one? Can it be done using IF formula?
And also i am using this checkbox to function something else as TRUE/FALSE.
If I have the start date (say February 01, 2009) and the job will take 100 working days, when will it finish if there is no work done over weekends? I assume you can use networkdays somehow but the final logic escapes me
View 2 Replies View RelatedI made a sheet to control some reports, and it works like this: you click a button ("Insert"), it opens a userform, you type everything there (date, serial number, client, city) and it place that info on the first row available. Then there's a "Clear Last Entry" button, and that's it.
I would like to protect the whole sheet and only allow users to insert new entries via the "Insert" button. How can I do this? If I protect normally Excel won't allow the VBA code to write on cells.