Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 45
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 108
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to make a macro COLLEGE GIRL Excel Discussion (Misc queries) 1 July 28th 09 07:12 AM
I think I want to make a Macro Linda RQ New Users to Excel 2 June 26th 07 02:23 AM
anyway to make a macro for all of excel mithu Excel Discussion (Misc queries) 6 March 21st 07 04:38 PM
make a macro to insert a macro mithu Excel Discussion (Misc queries) 6 March 20th 07 06:04 PM
Help Me Make Macro Aamer Excel Discussion (Misc queries) 1 September 4th 05 01:34 PM


All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"