+ Reply to Thread
Results 1 to 2 of 2

Confirm Command button on user form using VBA

  1. #1
    Forum Contributor
    Join Date
    11-20-2009
    Location
    Melbourne
    MS-Off Ver
    Excel 365
    Posts
    261

    Confirm Command button on user form using VBA

    I have code that checks a checkbox after a certain name has been selected from a drop down list on a Userform.
    This in turn, performs other commands automatically. Once these commands have finished, an Okay button appears.
    How would I write VBA that will action the Command Button (ie: Confirm 'Okay') without the necessity to press it?
    Thank you for help.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Confirm Command button on user form using VBA

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

+ 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] Restricting command button action in a user form
    By coach.32 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-03-2013, 01:28 AM
  2. Want to add disply and edit command button in user form- :(
    By sinha.riteshabap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2013, 03:21 AM
  3. Help to creat user form with command button
    By sheree08 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2013, 04:10 PM
  4. User form RTE 13 when opening with a command button on a worksheet
    By iaingidley in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-08-2011, 11:50 AM
  5. Command Button on User form for Printing
    By Anthony Slater in forum Excel General
    Replies: 2
    Last Post: 09-07-2005, 03:05 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