Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #107980
| From | "JCO" <someone@somewhere.com> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: User Selection as to which Function to Run |
| Date | 2015-08-18 18:05 -0500 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <mr0dn7$e3m$1@speranza.aioe.org> (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> |
"GS" wrote in message news:mqjcbk$1t8$1@dont-email.me... "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
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll 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