Can a Macro as well as a Userdefined Function exist in a single module.

Upon entering a Macro code manually how can you access or assign a short key
to it?

Thanx!!!

Lets say that you have already entered a macro manually and want to assign a
shortcut to it. From the Excel window:

ALT-F8
Select the macro
Options...
enter the shortcut.

--
Gary''s Student - gsnu200768


"FARAZ QURESHI" wrote:

Can a Macro as well as a Userdefined Function exist in a single module.

Upon entering a Macro code manually how can you access or assign a short key
to it?

Thanx!!!

First question.........yes.

Second, see other reply.


Gord Dibben MS Excel MVP

On Mon, 11 Feb 2008 00:51:01 -0800, FARAZ QURESHI
wrote:

Can a Macro as well as a Userdefined Function exist in a single module.

Upon entering a Macro code manually how can you access or assign a short key
to it?

Thanx!!!