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

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

Bob,

Thanks. I'm sure I'll wonder how I got along without it.

Alan

--
achidsey


"Bob Phillips" wrote:

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