C
crarbo1
Hello,
I'm wanting to automatically create a macro in Excel 2000 when I click
a command button. I'm using a command button from the control toolbox.
My example is as follows:
Click a button that is assigned a macro called "Macro1"
"Macro1" then executes some code and a macro called "Macro2"
"Macro2" executes some code that creates a new worksheet, adds a
command button from the control toolbox, names the control button, and
then creates "Macro3" for use of the control button created in
"Macro2" automatically all using vba.
I can do everything above except create "Macro3" automatically using
vba for excel 2000.
I'm sure I'm missing something simple but it is not clicking right now
as to what I need to do.
Can anyone help me out? If you need more info, please let me know.
Thanks,
Chuck
I'm wanting to automatically create a macro in Excel 2000 when I click
a command button. I'm using a command button from the control toolbox.
My example is as follows:
Click a button that is assigned a macro called "Macro1"
"Macro1" then executes some code and a macro called "Macro2"
"Macro2" executes some code that creates a new worksheet, adds a
command button from the control toolbox, names the control button, and
then creates "Macro3" for use of the control button created in
"Macro2" automatically all using vba.
I can do everything above except create "Macro3" automatically using
vba for excel 2000.
I'm sure I'm missing something simple but it is not clicking right now
as to what I need to do.
Can anyone help me out? If you need more info, please let me know.
Thanks,
Chuck