Results 1 to 6 of 6

Assign macro to user form checkbox without running it

Threaded View

  1. #1
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Assign macro to user form checkbox without running it

    I've created a userform containing multiple checkboxes and I want to assign a macro to each checkbox without running the macro when the checkbox is checked. Ideally, each macro is assigned, you select all the checkboxes planned to run, and afterwards you run all the macros, based on a userform button. Currently it looks like bellow.
    Anyone may have some hints on how to make this possible?
    Attached Images Attached Images
    Click the * to say thanks.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA User Form Issues - Check boxes greyed out after running macro
    By piper9497! in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2019, 05:17 PM
  2. How to assign VBA code to user form controls
    By pedropumpalot in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2015, 08:18 PM
  3. [SOLVED] Grey our a checkbox (not on a user form)
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-05-2014, 04:34 PM
  4. [SOLVED] Running a Copy Row Macro From a User Form (Easy Fix I Think)
    By lsteinbach in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-10-2013, 04:29 PM
  5. [SOLVED] (updating inventory using user form) : Assign macro to "Çheck Availibility" command button
    By pyol17 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-08-2012, 06:50 AM
  6. User Form During Macro Running
    By mido609 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2012, 06:17 PM
  7. [SOLVED] How to: User Form to assign a user defined range to a macro variab
    By TrevTrav in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2005, 04: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