As you'll see, the following code is associated with this control (this is my original code, but I'll be happy to use any code that Why can't I create a Permissions Level? Promoted by Recorded Future Do you know the main threat actor types? The code works if I create a UserForm in Visual Basic View, but I would like the checkbox to be on Sheet2. 1) In Excel 2003, I put a checkbox from his comment is here
Since it isn't working, I am betting you have a Forms type control. Hi, I am trying to use a check box in an excel sheet. Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Sheet1.Visible = xlSheetHidden Else Sheet1.Visible = xlSheetVisible End If End Sub Apr 5 '07 #1 Post Reply Share this Question 7 Replies Expert more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed
Finally, on the Visual Basic toolbar, press the Design Mode button; and then, right-click on the CheckBox and select properties. The code looks like what you posted--but it won't work unless you put it on the code pane for the worksheet containing the checkbox. Now user has to select few bluetooth devices. How to write "Play this line, OR this line" with conventionnal music symbols Why were weapons like Mandrakes and Acromantula, which kill indiscriminately, used in the Battle of Hogwarts?
I have tried a lot things but can't get this to work. May 19 '10 #4 reply P: 9 rosshughson @QVeen72 HI. The code given so far is for the Control Toolbox type. Results 1 to 4 of 4 Thread: Object Required: Referring To Check Box Thread Tools Show Printable Version Search Thread Advanced Search December 7th, 2006 #1 Six Strings Guest Object
The time now is 04:14 AM. It's quick & easy. If I change the code to: Please Login or Register to view this content. Had you used an ActiveX checkbox, it likely would have been named CheckBox1 and a click event macro in the Sheet1 code pane could have referred to CheckBox1 successfully.
or Please Login or Register to view this content. The time now is 04:14 AM. Checkbox1 is the only control I've generated. Register To Reply 09-25-2007,02:53 AM #9 lottesfog View Profile View Forum Posts Registered User Join Date 08-28-2007 Posts 48 Hi Leith, Thank you - you are correct, I was using the
It should be simple. click to read more I even tried the other way: 1) I right clicked the checkbox and selected "Assign Macro", then "New" and it opens VBA Editor and a new module is created which I Checkbox Object Required Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures. Can you remove the second if clause and just specify Worksheets(1).Activate and MsgBox("Awesome") in the next line? –nhee May 31 '15 at 13:12 | show 13 more comments Your Answer
Notice that if you change the name, your code no longer works. this content Why would a NES game use an undocumented 1-byte or 2-byte NOP in production? Lotte Last edited by VBA Noob; 10-24-2007 at 04:23 AM. Yes, it is possible to not use a cell link, but you will drive you sucessor insane, so I'm not going to show you.
You need to know exactly which type of checkbox you have. 0 LVL 80 Overall: Level 80 MS Office 28 MS Applications 17 Message Active 2 days ago Expert Comment Share it with others Like this thread? asked 1 year ago viewed 725 times active 1 year ago Linked 146 Where does VBA Debug.Print log to? 0 Looping INDEX-MATCH VBA with Sub or Function not defined error Related weblink Why does Excel not recognise the check box as an object?
In doing this, I had one more question if you have the time. Could mollusks become extremely large? If CheckBox1.Value = False Then I have tried putting the spreadhsheet name in front of the checkbox name eg - If MAIN.CheckBox1.Value = False Then but that didn't help.
I then inserted 3 lines to read the value of the checkbox and display a MsgBox if the checkbox is checked. I think you can regard 2 & 3 as basically the same but it might be that they are different data types. P: 9 rosshughson I have added 4 checkboxes to a spreadsheet and want my macro to check the value of each one. Join & Ask a Question Need Help in Real-Time?
Thank you. I just tried putting it under worksheet_change, but now I'm getting a runtime error (424 object required). Type in a new name for the checkbox 4. http://mwdsoftware.com/object-required/vba-error-424-object-required.php Join & Write a Comment Already a member?
Tools, Macro, Record New Macro. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Are there any lawyers mentioned in Harry Potter? Theen there's much less overhead compared to the other suggestion.
Click in the Address bar to the left of the Formula bar. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 13th, 2004,09:55 AM #6 jimboy Board Regular Join Date Apr 2002 Posts 2,314 Re: Check box object required LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode What dice mechanic gives a bell curve distribution that narrows and increases mean as skill increases?
Thanks for your help. Notice that on the left, you have the Project Explorer and Sheet1 is gray, Also the Taskbar says that you are editing Sheet1 (Code). Try this code... A screenshot showing my checkbox in cell A1 -- ExcelScreenshot.png 3.
Assuming it's on the worksheet, and from the forms toolbox, the following should work and from there it's trivial to modify it to suit your application. Office / Productivity Office Suites-Other MS Office MS Word Advertise Here 757 members asked questions and received personalized solutions in the past 7 days. Once you have just the four toolbars, press Close. Actually I'm creating one excel document which contains list of bluetooth devices.
© Copyright 2017 mwdsoftware.com. All rights reserved.