[AccessD] OT: Excel input range

Hi Jim - thank you. I will put together a sample and send it tomorrow.

Rgds
Kath
  ----- Original Message ----- 
  From: Hale, Jim 
  To: 'Access Developers discussion and problem solving' 
  Sent: Saturday, November 22, 2003 10:03 AM
  Subject: RE: [AccessD] OT: Excel input range


  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
  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com