Results 1 to 6 of 6

How evaluate clicked commandbuttons on form

Threaded View

  1. #1
    Registered User
    Join Date
    10-09-2019
    Location
    Amsterdam, The Netherlands
    MS-Off Ver
    Office 2019
    Posts
    2

    How evaluate clicked commandbuttons on form

    I have a form with a group of three commandbuttons: if a user clicks just one of the commandbuttonvalues is True, the other two are false. While the form is still open I have to evaluate which button has been clicked, so a sub procedure can be started. I have two questions:
    1. I managed evaluate the clicked button indirectly by declaring three Public variables, but I think that that is a very poor method. Is there a better and more robust way to do that?
    2. I want to change the color of the caption of the clicked button, but my attempts sofar failed.
    See my attachment.
    Can someone help me out? Thanks very much in advance.
    Attached Files Attached Files
    Last edited by HJWNap; 08-21-2023 at 03:50 PM. Reason: typing mistake

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Captions of CommandButtons disappear after buttons are clicked
    By elfsprin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-10-2024, 11:34 AM
  2. [SOLVED] How do i test if a form (not MsgBox) button is clicked?
    By Platempole in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-21-2022, 05:12 AM
  3. Is there a way to save a form without its CommandButtons?
    By Wouldsman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-12-2015, 12:05 PM
  4. How to disable a Form Control Burron once Clicked?
    By vhache in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2015, 02:55 PM
  5. Automatic attachment of a form to a particular email when clicked....
    By jaysakle in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-04-2014, 03:18 AM
  6. [SOLVED] How to pop a form when clicked on cell
    By meprad in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-22-2013, 12:25 AM
  7. Using a Form Button to add 1 to a cell each time it is clicked
    By a.mack123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-14-2010, 03:16 AM

Tags for this Thread

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