+ Reply to Thread
Results 1 to 2 of 2

Linking a CheckBox to the Selection of a Command Button

  1. #1
    Registered User
    Join Date
    08-17-2021
    Location
    Milwaukee, Wisconsin
    MS-Off Ver
    2102
    Posts
    7

    Linking a CheckBox to the Selection of a Command Button

    Hey everyone,
    I created a thread yesterday and I thought of a revision I could make but still need help on if anyone can help:

    I originally thought I could highlight a UserForm command button once it is selected, but I figured linking a checkbox to each button would be simpler for whoever has to re-code the entire workbook once I leave the job I'm at now.
    Highlight Set Map.PNG

    It is essentially the same function, but instead of highlighting the command button, the checkbox is just selected when the command button is selected.

    If anyone has any ideas please let me know. Thanks

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,411

    Re: Linking a CheckBox to the Selection of a Command Button

    why not simply toggle the button backcolor ?
    Attached Files Attached Files
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

+ 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. [SOLVED] How to select a option button based on a command button selection and cell value
    By machoman4lyf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2018, 02:19 PM
  2. Hide/Unhide Command Button using CheckBox
    By Dbeethekidd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2014, 01:18 PM
  3. [SOLVED] Command Button disabled until checkbox selected
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2013, 10:35 AM
  4. [SOLVED] Linking together an Options Button and a command button inorder to load separate forms
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2013, 02:10 PM
  5. clearing a checkbox wth command button
    By shakey775 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2012, 05:37 PM
  6. Command Button to clear checkbox
    By zplugger in forum Excel General
    Replies: 2
    Last Post: 06-26-2011, 09:36 AM
  7. deleting a row with checkbox and command button
    By student123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2005, 02:19 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