Ken McLennan wrote:

G'day there One & All,

A quick query that may have been discussed herre, but that I'm
unaware of.

I was just wondering whether there was a plug in, or macro set, or
some form of addon that allows a user to store snippets of code to be
reused in later projects. I had in mind that in the VB Editor one
could assign macros to selected key combinations and just insert the
desired lines of code.

Is there any such thing? I know there are other IDE's and editors
that can do this sort of thing, but is there anything available for
the MS Editor that comes with Excel?

Or can you do that anyway but I've never found out how?

See ya
Thanks in advance,
Ken McLenan
Qld, Australia

If you use OOP using Class modules, you can re-use these objects.

--
Amedee Van Gasse using XanaNews 1.16.3.1
If it has an "X" in the name, it must be Linux?
Please don't thank me in advance. Thank me afterwards if it works or
hit me in the face if it doesn't. ;-)

G'day there Amedee,

If you use OOP using Class modules, you can re-use these objects.

I'm still working on that. I understand the concept from the
little I've read of Python, but I've yet to do anything with VB classes
in Excel. I've not needed to really, none of my projects were of such a
nature that it was desirable. That will be changing shortly, as I've got
a couple of biggies I've been asked to work on in the office. (I'm not
an XL guru, just an enthusiast who's prepared to do it in his own time
for no money <g ).

See ya
Ken McLennan
Qld, Australia