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