View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Macros with the VBE

Get hold of a utility called MZTools, http://www.mztools.com/. It already
has such functionality.

--
HTH

Bob Phillips

"achidsey" (notmorespam) wrote in message
...
Excel Experts,

Is it possible to write macros that work within the VBE?

For example, I would like to create a macro, that I would assign a

ShortCut
key (say Shift+Ctrl+F) to, that would generate the following line of code:

Cells.Find(What:="").Select

Is there a way to do this?
If so, where are such macros stored?

Thanks,
Alan

--
achidsey