Results 1 to 8 of 8

Name checkbox with vba

Threaded View

  1. #1
    Registered User
    Join Date
    01-29-2019
    Location
    Roermond
    MS-Off Ver
    365
    Posts
    25

    Name checkbox with vba

    Dear forum,

    In a userform are multiple checkboxes. The come in sets of two (yes or No)
    If a checkbox is clicked (true) then a cell value in sheet1 = "yes"

    Upon 'Initialize' I want the backcolor of one of two checkboxes to change.
    To do this I've assigned an ID to every couple of checkboxes
    For example:

    HTML Code: 
    The checkboxes in the userform are cb1 and cb2 etc.
    When running this code I get an error 91, object variable with, etc..

    Please help.
    Or is there a better way to do this? Sure there is, however....

    Regards, Rudy
    Last edited by ruud1957; 02-24-2019 at 09:13 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Make Worksheet Active-X CheckBox value same as Userform CheckBox value
    By L plates in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2016, 08:23 AM
  2. 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
  3. Protect the sheet but the form checkbox still can be change and sort by checkbox
    By carolyn1221 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-19-2014, 01:08 PM
  4. Replies: 0
    Last Post: 04-07-2014, 12:22 PM
  5. Lock cell linked to checkbox when checkbox is ticked
    By simeony003 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2013, 10:08 AM
  6. Replies: 4
    Last Post: 07-22-2013, 01:37 PM
  7. [SOLVED] How do I change a checkbox to unchecked without running the code within the checkbox
    By jsunnb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2012, 09:28 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