Open an excel Module
Hi everyone,
I am new to Excel VBA. I have a module that works perfectly. I do the following steps to run it: Open Module Alt_F11 F5 is there a faster way to do this? Thanks Ismail -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200612/1 |
Open an excel Module
hit alt-f8
highlight the macro click options assign a shortcut key -- Gary "ielmrani via OfficeKB.com" <u21259@uwe wrote in message news:6ab427a292af6@uwe... Hi everyone, I am new to Excel VBA. I have a module that works perfectly. I do the following steps to run it: Open Module Alt_F11 F5 is there a faster way to do this? Thanks Ismail -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200612/1 |
Open an excel Module
tools|macro|macros (or alt-f8)
and then select the procedure you want and click Run Someday you may want to provide a "prettier" interface. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) "ielmrani via OfficeKB.com" wrote: Hi everyone, I am new to Excel VBA. I have a module that works perfectly. I do the following steps to run it: Open Module Alt_F11 F5 is there a faster way to do this? Thanks Ismail -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200612/1 -- Dave Peterson |
Open an excel Module
Thank you Gary. I learned something new today.
Gary Keramidas wrote: hit alt-f8 highlight the macro click options assign a shortcut key Hi everyone, I am new to Excel VBA. I have a module that works perfectly. I do the [quoted text clipped - 9 lines] Ismail -- Message posted via http://www.officekb.com |
All times are GMT +1. The time now is 12:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com