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