Jim,

I am not too sure that your understanding of a userform are the same a
mine. The userform that I use is part of the VBE scenario.

Notwithstanding that, if you go to Tools in the Excel menu sheet an
select Macro from the resulting dropdown menu, select 'Record ne
macro..' there is a box that will alow you to add a shortcut key t
activate the macro.

If you already have an existing Macro then instead of 'Record Ne
Macro' select the Macro itself and then Options. The same shortcut ke
facility is available from the reulting dialogue box.

HTH :

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com