Have a Macro create a Macro
 

How do you create a VBA Macro to create a VBA Macro

When I run my Macro I want it to insert a button on a spreadsheet

Then insert code linked to that button which links to a Form

Insert a Form

Edit Form so it has appropriate buttons

Then Insert code into that form

---------------------------------------------

So in essence, my program has a button that will insert another macr
program into any workbook of my choice (that is if I can write th
program

--
Message posted from http://www.ExcelForum.com

Have a Macro create a Macro
 

http://www.cpearson.com/excel/vbe.htm

at Chip Pearson's site will give basic information on writing code with
code.

http://j-walk.com/ss/excel/tips/tip76.htm
at John Walkenbach's site shows how to create a form programmatically.

--
Regards,
Tom Ogilvy



"Langy " wrote in message
...
How do you create a VBA Macro to create a VBA Macro

When I run my Macro I want it to insert a button on a spreadsheet

Then insert code linked to that button which links to a Form

Insert a Form

Edit Form so it has appropriate buttons

Then Insert code into that form

---------------------------------------------

So in essence, my program has a button that will insert another macro
program into any workbook of my choice (that is if I can write the
program)


---
Message posted from http://www.ExcelForum.com/

Have a Macro create a Macro
 

Tom Ogilvy wrote:

http://www.cpearson.com/excel/vbe.htm

at Chip Pearson's site will give basic information on writing code
with code.

Don't use McAfee VirusScan ASaP if you use Chip's methods.

http://j-walk.com/ss/excel/tips/tip76.htm
at John Walkenbach's site shows how to create a form
programmatically.

--
Amedee Van Gasse using XanaNews 1.16.3.1
If it has an "X" in the name, it must be Linux?
Please don't thank me in advance. Thank me afterwards if it works or
hit me in the face if it doesn't. ;-)