right click pop-up menu

[Guest]

Do you mean that my function name must be sometihng like '=QuickClose'

My code should look like following

private sub =QuickClose()

response = msgbox("hello", mbOK)

end sub

Your help is great appreciated,

 

[Rick Brandt]

Do you mean that my function name must be sometihng like '=QuickClose'

My code should look like following

private sub =QuickClose()

response = msgbox("hello", mbOK)

end sub

No, I mean you enter...

=QuickClose()

....as the menu action property.

 

[Guest]

I got following message:

Db1 can't find the macro 'QuickClose'
The macro (or its macro group) doesn't exist, or the macro is new but hasn't
been saved.
Note that when you enter the macrogroupname.marcroname syntax in an
argument, you must specify the name the macro's macro group was last saved
under

I think something wrong with my syntax or link.
Any suggestions,

Thanks millions,

 

[Guest]

Thanks for theinformation,
It should link to macro and macro call VBA functions.
Am I right?

Thanks again,

 

[Rick Brandt]

Thanks for theinformation,
It should link to macro and macro call VBA functions.
Am I right?

You can enter either the name of a macro or the name of a VBA function. In
the case of a VBA function you have to put the equals sign in front. If
it's easier you could use the name of a macro and have the macro call your
VBA routine, but I just avoid macros since they can't handle errors.