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


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

Re: Manage errors with multiple InPut Boxes

From GS <gs@v.invalid>
Newsgroups microsoft.public.excel.programming
Subject Re: Manage errors with multiple InPut Boxes
Date 2015-10-02 14:40 -0400
Organization A noiseless patient Spider
Message-ID <mumiui$gc7$1@dont-email.me> (permalink)
References (4 earlier) <33befbcc-7f23-43e3-a84c-593d4f21caea@googlegroups.com> <muccru$6ec$1@dont-email.me> <79dbb560-e675-498c-b659-05f9e5bf95d5@googlegroups.com> <muhv3o$pa2$1@dont-email.me> <b0ed3470-3c77-4bff-ab1b-bc7c558e7e08@googlegroups.com>

Show all headers | View raw


>> 
>> Well.., I should keep it very basic then. (user input to worksheet 
>> range)
>> 
>> N.B.: my modem is acting up and so the cable company is coming 
>> Friday  to fix/replace. I'll have only intermittent internet access 
>> until then!
>> 
>> -- 
>> Garry
>> 
>
>
> That would be fine.
> Thanks.
>
> Howard

Hi Howard,
I haven't mustered the energy yet to do a separate example project, but 
as an afterthought you might want to try using Excel's DataForm. Just 
make sure the data table has headers and fire the form up for user 
input. Worth a try since it's built-in specifically for that purpose. 
(The sheet need not even be visible if the dialog is code launched!)

-- 
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 | NextPrevious in thread | Next in thread | Find similar | Unroll thread


Thread

Manage errors with multiple InPut Boxes "L. Howard" <lhkittle@comcast.net> - 2015-09-28 01:42 -0700
  Re: Manage errors with multiple InPut Boxes Claus Busch <claus_busch@t-online.de> - 2015-09-28 12:22 +0200
    Re: Manage errors with multiple InPut Boxes "L. Howard" <lhkittle@comcast.net> - 2015-09-28 04:15 -0700
      Re: Manage errors with multiple InPut Boxes "L. Howard" <lhkittle@comcast.net> - 2015-09-28 05:05 -0700
        Re: Manage errors with multiple InPut Boxes "L. Howard" <lhkittle@comcast.net> - 2015-09-28 05:10 -0700
          Re: Manage errors with multiple InPut Boxes Claus Busch <claus_busch@t-online.de> - 2015-09-28 14:26 +0200
            Re: Manage errors with multiple InPut Boxes "L. Howard" <lhkittle@comcast.net> - 2015-09-28 05:48 -0700
  Re: Manage errors with multiple InPut Boxes Claus Busch <claus_busch@t-online.de> - 2015-09-28 12:28 +0200
  Re: Manage errors with multiple InPut Boxes GS <gs@v.invalid> - 2015-09-28 08:59 -0400
    Re: Manage errors with multiple InPut Boxes "L. Howard" <lhkittle@comcast.net> - 2015-09-28 07:21 -0700
      Re: Manage errors with multiple InPut Boxes Claus Busch <claus_busch@t-online.de> - 2015-09-28 17:43 +0200
      Re: Manage errors with multiple InPut Boxes GS <gs@v.invalid> - 2015-09-28 12:21 -0400
        Re: Manage errors with multiple InPut Boxes "L. Howard" <lhkittle@comcast.net> - 2015-09-28 09:45 -0700
          Re: Manage errors with multiple InPut Boxes GS <gs@v.invalid> - 2015-09-28 17:54 -0400
            Re: Manage errors with multiple InPut Boxes "L. Howard" <lhkittle@comcast.net> - 2015-09-29 19:01 -0700
              Re: Manage errors with multiple InPut Boxes GS <gs@v.invalid> - 2015-09-30 20:36 -0400
                Re: Manage errors with multiple InPut Boxes "L. Howard" <lhkittle@comcast.net> - 2015-10-01 00:15 -0700
                Re: Manage errors with multiple InPut Boxes GS <gs@v.invalid> - 2015-10-02 14:40 -0400
                Re: Manage errors with multiple InPut Boxes "L. Howard" <lhkittle@comcast.net> - 2015-10-02 13:41 -0700
                Re: Manage errors with multiple InPut Boxes GS <gs@v.invalid> - 2015-10-02 16:46 -0400
                Re: Manage errors with multiple InPut Boxes GS <gs@v.invalid> - 2015-10-03 13:21 -0400

csiph-web