[AccessD] OT Excel refer to form control

Kath

It should be the After Update  event, not the On Change event.
  ----- Original Message ----- 
  From: Garraway, Alun 
  To: Access Developers discussion and problem solving 
  Sent: Friday, November 21, 2003 1:06 AM
  Subject: AW: [AccessD] OT Excel refer to form control


  ok

  create a modul and declare a public variable.

  then for the combo on change event
  try this:

  Private Sub cboSheet1_Change()
      
      myVar = Me.cboSheet1.Value
      
  End Sub

  note: cboSheet1 is the name of my combobox
  and MyVar is the public variable in the modul
  hth
  alun


  -----Ursprüngliche Nachricht-----
  Von: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von Kath
  Pelletti
  Gesendet: Freitag, 21. November 2003 09:46
  An: Access Developers discussion and problem solving
  Betreff: Re: [AccessD] OT Excel refer to form control


  Hi Alan - it's just on the worksheet.
  Kath
    ----- Original Message ----- 
    From: Garraway, Alun 
    To: Access Developers discussion and problem solving 
    Sent: Friday, November 21, 2003 7:35 PM
    Subject: AW: [AccessD] OT Excel refer to form control


    hi Kath,

    is the control on an excel worksheet or are u using
    a userform?

    alun

    -----Ursprüngliche Nachricht-----
    Von: accessd-bounces at databaseadvisors.com
    [mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von Kath
    Pelletti
    Gesendet: Freitag, 21. November 2003 00:38
    An: AccessD at databaseadvisors.com
    Betreff: [AccessD] OT Excel refer to form control


    Can anyone tell me how to refer to a form control in Excel (in this case a combo box) so that I can read its contents into a variable in vba?

    Urgent.
    TIA


    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
  _______________________________________________
  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