Excel / VBA - How to add or remove the description displayed on the "Macro" pop-up

[hscowan]

Hi,

I am trying to find how to add or remove the description displayed on
the "Macro" pop-up menu (Alt-F8). Generally macros recorded have a
banale description giving the time/date & username, others that I write
directly in the VBE have none.

Can anyone point how to add/modify this description?

thanks,
Scott

 

[Bob Phillips]

Scott,

When the macro recorder fires up, the first dialog allows you to put
whatever description you want in, including none if so desired.

The value gets saved as comments, but changing the comments does not change
the pop-up description that I can see.

Is that not good enough?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[pfsardella]

(1) On the menubar in Excel : Tools > Macro > Macros
(2) Select the macro.
(3) Click the 'Options' button.
(4) In the 'Description' box, enter your description (or Ctrl V to
paste into this box).

HTH
Paul

 

[J.E. McGimpsey]

One way:

When you first choose Tools/Macro/Record New Macro, a dialog pops up
asking where to put it. In that dialog, there's a textbox for the
description.

To change it later, choose Tools/Macro/Macros.... Select the macro
and click Options. The dialog that opens has a textbox with the
description for you to edit.

 

[Dave Peterson]

tools|macro|macros...
type in your function name (you won't be able to see it on the list)
(when you spell it correctly, the buttons on the right hand side will be
enabled)

Then click Options
type what you want

I like to give short descriptions of the function's parameters are. (I'm not
sure anyone else has ever read them, but I sometimes do!)

 

[hscowan]

Thanks Dave,

I should have indicated that I want to add/edit this description
programatically in the VB editor. I assume that this would be a
property or something similar but haven't found it.

Any ideas?

thanks,
Scott

 

[Dave Peterson]

Take a look at MacroOptions in VBA's help:

Option Explicit
Function test(rng As Range) As Double
test = rng.Value * 3
End Function
Sub auto_open()
Application.MacroOptions macro:="test", Description:="Hi there"
End Sub

But once you set the description and save the workbook, it's there until you
change it. (I like the manual method <bg>.)

 

[hscowan]

Thanks!

Consider this closed...