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.
Well there is no difference!!
Perhaps simply...
Sub Run3Macros()
Call Macro1
Call Macro2
Call Macro3
End Sub
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion