Macro to Make a Macro
 

Hi all,

Does anyone know how to use a macro that can create a command button and
then write a simple piece of code to create a new macro, for arguements sake,

Private Sub CommandButton1_Click()
msgbox "Hello"
End Sub

Is there anyway of writting that code within VBE using a macro

Thanks

Andy

Macro to Make a Macro
 

Roedd <<Momo wedi ysgrifennu:

Does anyone know how to use a macro that can create a command button
and then write a simple piece of code to create a new macro, for
arguements sake,


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

--
Rob

http://www.asta51.dsl.pipex.com/webcam/

This message is copyright Robert Bruce and intended
for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.