Results 1 to 7 of 7

How to reference/set a checkbox value

Threaded View

  1. #1
    Registered User
    Join Date
    06-26-2006
    Posts
    44

    How to reference/set a checkbox value

    So I had several form-based checkboxes and I can't seem to reference them or change their value in VBA. Perhaps I'm simply not referencing them correctly. I'm currently trying:
    Private Sub SundayNoonBox_Click()
        If 1 = MondayNoonBox.Value Then
            TuesdayNoonBox.Value = 1
        Else
            TuesdayNoonBox.Value = 0
        End If
    End Sub
    Also, it appears that code like this won't run unless it's in the Sheet1 code block and not in a Module code block? (Also, you have to be in Design Mode to delete a module, apparently.)
    Last edited by Banaticus; 09-28-2014 at 01:24 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Can I access a checkbox control using a cell reference to get the name?
    By batman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2014, 09:34 PM
  2. [SOLVED] How to use a String to reference to a CheckBox object?
    By excelnewbie80 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2012, 03:59 AM
  3. Reference checkbox using linked cell address
    By chewie in forum Excel General
    Replies: 3
    Last Post: 06-02-2011, 02:11 PM
  4. Reference if Checkbox is checked on Worksheet_Change
    By LampCommandr in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-11-2011, 10:48 AM
  5. Checkbox reference
    By Nick_in_Dubai in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2009, 03:03 AM

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