+ Reply to Thread
Results 1 to 2 of 2

Checkbox Macros

  1. #1
    Registered User
    Join Date
    02-01-2017
    Location
    Houghton, Michigan
    MS-Off Ver
    2013
    Posts
    1

    Checkbox Macros

    I inserted a check box on a sheet and would like to use it's status in some VBA code. I assigned it to a macro with the following code.

    Please Login or Register  to view this content.
    updTALAclasslist is a Public boolean variable that I would like to use in another 'Sub'

    However I get the following error message.
    Object doesn't support this property or method (Error 438). On the following line.
    Please Login or Register  to view this content.

    Any help in getting this to work would be appreciated
    Last edited by cesannes; 02-01-2017 at 02:12 PM.

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Checkbox Macros

    Hi cesannes,

    Please edit your post to include code tags.... highlight the code portion of the post, and hith the # symbol in the menu. This is pertaining to rule #3 of the forum rules

    Then please let us know what line returns the error, and is the checkbox a form or activeX control? Ideally provide us with a workbook displaying the issue.
    Last edited by Arkadi; 02-01-2017 at 02:04 PM.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Select All Checkboxes Checkbox That Also Calls Checkbox Macros
    By Intervigilium in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2015, 06:41 PM
  2. [SOLVED] Excel checkbox macros
    By darchaf in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2012, 12:44 AM
  3. Excel 2008 : checkbox automatic macros
    By bigboiprob in forum Excel General
    Replies: 2
    Last Post: 09-25-2011, 03:04 AM
  4. Need help with checkbox's and macros!
    By ollierice in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2011, 12:39 PM
  5. Checkbox Macros
    By pgwolfe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2008, 10:49 AM
  6. Checkbox and macros
    By Barrett9699 in forum Excel General
    Replies: 1
    Last Post: 08-27-2006, 02:04 PM
  7. [SOLVED] checkbox and macros
    By Tdebb8594 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1