View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default User Selection as to which Function to Run

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