Results 1 to 27 of 27

Add Command Buttons to User Form at Runtime

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Add Command Buttons to User Form at Runtime

    I have a number of macros that I would like to call from a User Form. I want to be able to pass an array of the names of these macros to a function that will runtime create a UserForm with Command Buttons linked to these macros. Is anybody able to assist with this?

    Attached is as far as I have got.

    I am having difficulty with the following:
    1. Create the form dynamically (currently using the first form in ThisWorkbook)
    2. Spacing the Cmd Buttons over the form (currently overwriting the same button)
    3. Adding the Calls to the Command Buttons
    Attached Files Attached Files
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Option buttons on a user form
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2013, 07:39 AM
  2. [SOLVED] Call command buttons by user-defined names
    By Willardio in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-14-2013, 10:58 AM
  3. command buttons with hyperlink to form
    By stats09 in forum Access Tables & Databases
    Replies: 4
    Last Post: 12-10-2010, 01:20 AM
  4. User Form Option & Command Buttons
    By Information Hog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2005, 06:37 PM
  5. Code Behind Buttons on User Form
    By robertguy in forum Excel General
    Replies: 0
    Last Post: 02-09-2005, 11:53 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