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

Problem with Parameters In External ODBC Data Queries and Userform
 

You will need to trigger the query again..

If this post helps click Yes
---------------
Jacob Skaria


"Bodo" wrote:

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

Problem with Parameters In External ODBC Data Queries and User
 

great, works like a charm.
I like to add that I deactivate the query's automatic background refresh,
otherwise this triggers an error.

Again many thanks.