Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: User Selection as to which Function to Run

From "JCO" <someone@somewhere.com>
Newsgroups microsoft.public.excel.programming
Subject Re: User Selection as to which Function to Run
Date 2015-08-13 14:31 -0500
Organization Aioe.org NNTP Server
Message-ID <mqirap$664$1@speranza.aioe.org> (permalink)
References <mq2u0f$43i$2@speranza.aioe.org> <mq818i$1ck$1@dont-email.me>

Show all headers | View raw

"Claus Busch"  wrote in message news:mq818i$1ck$1@dont-email.me...

Hi,

Am Fri, 7 Aug 2015 13:39:13 -0500 schrieb JCO:

> I want to query the user as to which function of 3-choices to run. I'm
> currently set up to select a range of data using the mouse, then run the
> proper 1 of 3 functions against the selection.

please look here:
https://onedrive.live.com/redir?resid=9378AAB6121822A3%214224
for "Function" and download the file because macros are disabled in
OneDrive.
Select a range with more than 1 cell and then select  the function.


Regards
Claus Busch
-- 
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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....lol

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next 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