Groups > microsoft.public.excel.programming > #107981

Re: User Selection as to which Function to Run

From	GS <gs@v.invalid>
Newsgroups	microsoft.public.excel.programming
Subject	Re: User Selection as to which Function to Run
Date	2015-08-18 19:54 -0400
Organization	A noiseless patient Spider
Message-ID	<mr0gft$ugq$1@dont-email.me> (permalink)
References	<mq2u0f$43i$2@speranza.aioe.org> <mq818i$1ck$1@dont-email.me> <mqirap$664$1@speranza.aioe.org> <mqjcbk$1t8$1@dont-email.me> <mr0dn7$e3m$1@speranza.aioe.org>

Show all headers | View raw

> 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

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

User Selection as to which Function to Run "JCO" <someone@somewhere.com> - 2015-08-07 13:39 -0500
  Re: User Selection as to which Function to Run Claus Busch <claus_busch@t-online.de> - 2015-08-07 21:08 +0200
    Re: User Selection as to which Function to Run "JCO" <someone@somewhere.com> - 2015-08-08 16:26 -0500
  Re: User Selection as to which Function to Run Claus Busch <claus_busch@t-online.de> - 2015-08-09 19:07 +0200
    Re: User Selection as to which Function to Run "JCO" <someone@somewhere.com> - 2015-08-13 14:31 -0500
      Re: User Selection as to which Function to Run GS <gs@v.invalid> - 2015-08-13 20:23 -0400
        Re: User Selection as to which Function to Run "JCO" <someone@somewhere.com> - 2015-08-18 18:05 -0500
          Re: User Selection as to which Function to Run GS <gs@v.invalid> - 2015-08-18 19:54 -0400

csiph-web