[AccessD] OT: Excel input range

Hale, Jim jim.hale at fleetpride.com
Fri Nov 21 17:03:35 CST 2003


If you send me a sample I will take a look at it on Monday.
regards,
Jim Hale

-----Original Message-----
From: Kath Pelletti [mailto:SDSSoftware at optusnet.com.au]
Sent: Thursday, November 20, 2003 11:24 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] OT: Excel input range


After a long day battling my way through this Excel development I am signing
off for now but in case any Excel gurus have the time, could you answer
this:

On an Excel s/sheet I have 3 combos (created with the form control). I have
nominated an input range for each (on a separate sheet). Depending on the
choice the user makes in Combo 1 and Combo 2, I need to modify the range for
Combo 3. What's the best way in Excel? I see on lots of internet samples
that quite often people set up range after range of values and nominate one
or the other as the appropriate range when the combos change, but surely
there is a more efficient way??

I have fairly simple rules from the client and I think that I should be able
to set up a grid /range of cells which hold my criteria. I can post sample
data if anyone thinks they can help.

Thanks everyone - and apologies for the Excel posts (I am also posting to
Excel sites but no luck yet). Have a great w/end.


Kath Pelletti
Software Design & Solutions Pty Ltd.
Ph: 9505-6714
Fax: 9505-6430
sdssoftware at optusnet.com.au
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list