"GS" wrote in message ...

"Thanks
This makes sense, but you had to use VB instead of Excel Macros (it
appears...?). That is okay, I'm not sure what the
advantages/disadvantages of using VB will have. I'm a bit confused
with Excel because it has its own set of Formulas, Macros & is native
to the VB Language. I never know the ramifications of using one over
the other.."

VBA (Visual Basic for Applications) is the macro language used with MS
Office and many other apps that use it for macros. Excel macros can
also be used as user-defined functions so they work in/as worksheet
formulas.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Thanks Garry,
Yeah I know VB is native to Excel. I guess I didn't make myself very clear.
I currently have a .bas file which is a general purpose utility that I
attach to different files just to help do the mundane tasks. I have 3-minor
routines that I wanted to combine a one routine (Macro). So it starts out
by determining the selection from the mouse, determines 1 of 3 Macros, then
executes it. So my real question was having the issue that my files are in
a .bas yet the dropdown list is in VB which will determine which of 3-macros
(in the .bas) file to execute. That's what I meant by advantages and
disadvantages of VB vs Macro routines.
JCO