View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bodo Bodo is offline
external usenet poster
 
Posts: 5
Default Problem with Parameters In External ODBC Data Queries and Userform

Hi all,

I have a sheet that gets its data from an external data query.
The parameter value of that query is set in cell A1 on the same sheet.
So when I edit cell A1 value and press enter, the sheet refreshes
automatically its data.

Now I build a User form that allows the user to pick a value from a combobox.
I set the combobox change event to the following code:

Set celObjektgruppe = Sheets("Objekte").Range("A1")
celObjektgruppe.Cells(1, 1).Value = Me!ComboBoxObjektgruppe.Value

When the event fires the value of cell A1 reflects the change but the
sheets data won't refresh.

Any ideas how to troubleshoot?

Thanks in advance.

--
Thanks in advance
Bodo