+ Reply to Thread
Results 1 to 2 of 2

Create Macro Button

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Create Macro Button

    Hello:

    Please refer to attached file.
    I have location of the VB Code (Macro) in column B.
    I need VB Macro for Buttons in column C which will create Macro Button for the macro in cell B1 and B2 and put the button at Cell A1 and A2.
    Need VB Code to perform this as i have lots of macro's in my daily files and hate to right click and Assign Macro etc.


    Let me know if you have any questions.
    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,449

    Re: Create Macro Button

    Hi riz,

    Before you venture into writing code that modifies other code read this:
    http://www.cpearson.com/excel/vbe.aspx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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] Using macro to create a Form Control Button and Assign macro to it in a specified Cell
    By weige1989 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2014, 11:51 AM
  2. Replies: 2
    Last Post: 02-03-2013, 06:38 AM
  3. Replies: 0
    Last Post: 01-15-2013, 08:18 PM
  4. Macro button to create new line?
    By Haze1434 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2009, 12:29 PM
  5. Create Option Button using Macro
    By Budi in forum Excel General
    Replies: 1
    Last Post: 08-28-2009, 04:15 AM
  6. A macro to create a form button, assign a macro and name the button
    By cl361 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2008, 01:07 AM
  7. Macro to Create a Button
    By Caligula in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-27-2007, 03:02 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