View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Attribute statements of VBA Classes

Hi Gogza,

I haven't got round to looking again at these attributes in VB, however VBA
does of course have a rather hidden dialog to add a description & help
context id.

In object browser, select project in the library & module name in classes
(includes normal modules), function name in members, right click
Properties.

The description appears in Excel's function dialog if it's a UDF.

Open the module in a text editor for the syntax.

Regards,
Peter T


"gogza" wrote in message
oups.com...
Wow, thanks Peter,

This is what i'm looking for.

What would be cool is if someone with VB could apply some of these
attributes to a class, export the .cls file and post it up here. Then I
could see the syntax, to try out in VBA.

No rush! This is just a matter of interest for me.

Thanks again,
Gogza