Check Value Of Checkbox On Worksheet
Dec 14, 2007
I have a problem to check the value of a checkbox when I write the code in Module1. I have several worksheets, and in each worksheet there is a CheckBox1. I want the macro (in Module1) to perform a given code when the CheckBox1.value = true and visa versa.
The code I'm using is as follows:
Option Explicit
Global ws As Worksheet
Application. ScreenUpdating = False
For Each ws In Worksheets
If CheckBox1.Value = True Then
'Do code1
Else
'Do code2
End If
Next ws
Application.ScreenUpdating = True
End Sub
When the Macro is run, an error msg is showing "RunTime error '91'.
Does anyone know how to make this macro function? I've searched the forum, but couldn't make any of the codes suggested to work.
View 3 Replies
ADVERTISEMENT
Sep 9, 2007
I am creating a userform with 10 checkboxes. The first 9 checkboxes are user options. I want the 10th check box to be a "Select All" option i.e. if the 10th checkbox is checked all the other 9 options are deemed to have been selected.
The way I want the display to work is that if the 10th checkbox is ticked all other checkboxes are cleared. Also if the 10th checkbox is ticked and any of the other check boxes is selected then the 10th checkbox should be selected.
I have tried coding this up but the checkboxes don't seem to operate as desired. I placed some code on the click event for the last option button to set the vlaue for all other buttons to false. This works but the 10th check box doesn't get ticked itself. When I try to code up the other bit I get similar issues.
View 9 Replies
View Related
Jan 7, 2010
I'm trying to check the value of a checkbox that I created in my workbook, but both of the if statements below say "Object does not support this property or method"
View 6 Replies
View Related
May 14, 2014
I have a userform1 with textbox1, checkbox1, checkbox2, checkbox3 and checkbox4. What i want to accomplish is
[Code]....
View 3 Replies
View Related
Aug 22, 2008
I am trying to write a macro for an option button, that when selected it checks to see if another option button is selected then continues to automatically change the value of 5 other option button within in 5 other group boxes
Sub SetFilter()
'check to see if filtering is required
If Sheet1.Shapes("Option Button 54").value = True Then
'set non-specific filtering
Sheet1.Shapes("Option Button 28").Value = xlOn
Sheet1.Shapes("Option Button 38").Value = xlOn
Sheet1.Shapes("Option Button 44").Value = xlOn
Sheet1.Shapes("Option Button 52").Value = xlOn
End If
End Sub
View 2 Replies
View Related
Nov 14, 2006
I 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 ...
View 4 Replies
View Related
May 1, 2014
I have a userform that has 28 checkbox's that we go through that we check which ones apply to a report.. To keep those boxes checked as the supervisor's cycle through the reports, I am leaving a 28 digit code next to the report which is created as they check/uncheck the proper checkbox's.
[Code].....
So if say CheckBox10.value = True, then the 10th digit of the ID will change to 1 while keeping the rest of the ID the same.
View 6 Replies
View Related
Mar 18, 2009
I received a spreadsheet form containing some checkboxes that I need to tick. The problem is I dont know how can I tick/show the check mark on the checkbox. everytime I double click it, macro vb screen appears.
View 4 Replies
View Related
May 18, 2009
It might be very simple, but all I need is if I have data on A1, and i have 3 check boxes labeled: NEW, EXISTING, and ARCHIVED. I want it to automatically check the corresponding boxes. So if "NEW" is typed under A1, it'll check "NEW" box. "EXISTING" will check "EXISTING" check box and so on.
View 4 Replies
View Related
Oct 1, 2006
How do i check a checkbox on an excel worksheet?
View 5 Replies
View Related
Jan 6, 2008
I have created a checkbox which places a "TT" on a master sheet when checked on the NEW8 sheet. What I want to know is how do I get the "TT" to delete from the master sheet when unchecked on the NEW8 sheet. Below is what I have...
View 9 Replies
View Related
Sep 13, 2007
I have a check box that when checked needs to take information from multiple cells and copy into multiple cells and then when uncheck remove the data from the cells.
I have attached a sample.
View 4 Replies
View Related
May 28, 2008
I am trying to allow the Command Button when clicked to go through multiple conditions before making a decision. So, when someone clicks on Command Button 3 the code should look to see if CheckBox1 is true, then it should check today's date, and if it is between a range of days, or even months, then it would add the number in TextBox1 with the amount already in cell H18. This event will happen every time someone clicks on the Command Button.
The end result is to have several sheets (4 total) for each quarter in the fiscal year, and if the dates are within those parameters, the clicking of the command button will update the correct sheet.
View 9 Replies
View Related
Jan 14, 2009
I need to get the state (xlon or xloff) of check boxes on a worksheet. i have tried the following but unable to get it to work.
View 3 Replies
View Related
Jan 4, 2013
I have a workbook containing many different sheets. What I want to accomplish is when I click on a check box on one sheet, I want the check box in a different worksheet to be unchecked. I have form control checkboxes in my workbook, so I used xlOff as the value.
Here's what I have in my VBA code.
Worksheets("February").CheckBoxes("CheckBox13").Value = xlOff
It is giving me the error "Unable to get the CheckBoxes property of the Worksheet class"
View 4 Replies
View Related
Jul 1, 2014
I have 71 checkboxes that I want to transfer the Checkbox Caption if true. If the checkbox is false I want to transfer a value of "0". The captions are being transferred to a different worksheet. Below are a few entries if I was to enter them all separately, but I assume there is a way to do all at once?
View 4 Replies
View Related
May 22, 2009
I am having difficulties with this one. I have a button on my worksheet (sheet1) that runs a macro.
View 4 Replies
View Related
Jan 18, 2013
I want to have a Checkbox (Form) that is in my Worksheet to disable/gray-out once it is selected. I don't want people to be able to uncheck it again. I want them to be forced to click another Checkbox to enable it again.
Example:
Two Checkboxes:
Check Box 1 = "Apply"
Check Box 2 = "Delete"
Once "Apply" is checked, gray it out. This will force a user to click "Delete" in order for the "Apply" button to be enabled again. I do not want a user to click "Apply" once selected as their way of 'deleting' the information.
View 1 Replies
View Related
Sep 22, 2006
I am creating a main worksheet (Legend) in which information will be entered and then populate to other areas (worksheets) within the workbook. I would like to create a print macro - that will run and print all the worksheets that we have selected on the "legend" page. These worksheets would have been selected by ticking a check box.
My question is how to associate a check box to a worksheet? For example - the second worksheet is named " Schedule A" 3rd "Schedule B" and so on.
- The check boxes will be name schedule A, Schedule B and so on.
- I would like to associate (link) the checkbox Schedule A with the Worksheet of the same name. Then when this checkbox is selected, and the print macro runs it will print the worksheets that are selected.
View 5 Replies
View Related
Feb 6, 2013
I have a userform with 17 checkboxes that their captions should correspond with column A range ("A2:A18) on a worksheet.
Is there a way in userform_initialize, or activate, to create the captions from that range?
I could type the code 17 times like;
Code:
me.checkbox1.caption = wb.worksheets("area").range("a2").value
I was curious to know if it could be looped? Textboxes on the same userform.
View 6 Replies
View Related
Feb 24, 2008
I have a userform where the textbox already pulls data from a worksheet. I have a checkbox next to the textbox, If the checkbox is true it finds the textbox value on a worksheet and using Offset it inserts "yes" in the next cell.
View 6 Replies
View Related
Jan 19, 2009
I have data in range J2:J365 , H368:H401 & J403:J827. i want to check wether this range have negative values or not if yes load all negative values in the listbox1 by clicking checkbox.
View 3 Replies
View Related
Feb 25, 2009
married, widows, single checkbox is selected
macro solution
good work.
View 5 Replies
View Related
Apr 16, 2014
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] .........
View 9 Replies
View Related
Feb 4, 2010
I would like a macro that adds a worksheet with the name say XML_JB to a workbook. I have ran the record button as shown in the code below but when I re-run the Macro the line tries to add the worksheet in Sheets("Sheet5").Select and I get a debug error. I realise the issue is around the fact that the count needs to be set some how as a variable and not set as Sheet 5 as the macro can't find sheet 5. The Macro also needs to check if the worksheet “XML_JB” is there and if so throw up a message like XML_JB already exists Do you want to continue? And if yes skip in adding of the worksheet and run my first macro. But as this is my second macro I don’t know how to go about it?
View 3 Replies
View Related
Dec 14, 2008
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.
View 6 Replies
View Related
Mar 10, 2009
i would like to know whether a worksheet exists or not... say, the worksheet name is sheet1, i need to check whether the worksheet exists... the point is, i need to delete the worksheet if it exists and execute a code... if the worksheet doesn't exist also, i need to execute the code... so im getting a little confused with this... i need something like this...
if sheet1_exists then
delete the sheet
end if
my_code.......
View 9 Replies
View Related
Jul 30, 2006
A workbook contains two worksheets. The first sheet is a membership list (Mem06) containing adresses and telephone numbers. The second sheet is a list of activity groups (Groups) with members details who are attending. There are 28 activity groups whose venues are scattered over 20 miles, each has a Leader. It is difficult for the Leader to know if those attending are paid up members, we know that some are lapsed. The solution is to get those members attending to complete a form with their name and 1st line of address. The membership secretary enters the names in the Group sheet (1st line of address only required when people have the same First and Surname).
We would like a formula to check this entry against the list in Mem06. If the entry corresponds the Telephone number for that entry would be returned to the Group sheet. Col A in both sheets has a formula to Concatenate First Name and Surname. The Telephone number in Mem06 is at Col I. The required formula would be in the Group sheet in the Telephone number col.
View 9 Replies
View Related
Nov 8, 2011
I have an array that opens a workbook containing close to 100 worksheets, and copies specific sheet names into there own individual workbooks. The problem I have now, is that I assume the worksheet exists in the workbook, but often times it does not Is there a way to add some sort of "catch" that will 1st verify the worksheet exists instead of my code crashing?
View 9 Replies
View Related
Mar 23, 2013
What is the simplest way to do it in VBA?
View 3 Replies
View Related
