Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Parameters In External ODBC Data Queries - "is one of" | Excel Discussion (Misc queries) | |||
Acess Queries, Parameters and VBA Problem | Excel Programming | |||
using odbc, get external data | Excel Programming | |||
Problem with CPU Usage 100% related to stored external queries | Excel Programming | |||
Help with External Data Queries | Excel Programming |