LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 49
Default Fetching a VBA Macro's Name During Execution

In all the macros I write, I put the name of the macro in
the title bar of all Msgbox and Inputbox msgs I generate.
Is there a VBA statement that will fetch the name of the
macro that is executing so I don't have to hard code the
macro name into my msgs? I want something like the code
that fetches the worksheet name that is currently active.
 
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
Incremental number for a fetching data The Ron Excel Worksheet Functions 1 November 9th 07 07:21 PM
Hide Macro's in Toolbar / Macro's list sparx Excel Discussion (Misc queries) 2 May 6th 06 08:53 PM
Fetching data from another worksheet c2k2 New Users to Excel 4 February 17th 06 04:57 PM
Fetching data from other sheets Palendromedary Excel Discussion (Misc queries) 3 December 21st 05 02:22 PM
Problem while fetching Excel records? Biju Excel Programming 3 November 6th 03 02:34 PM


All times are GMT +1. The time now is 03:07 AM.

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

About Us

"It's about Microsoft Excel"