We have got an Excel/VBA application working very well
with Excel 97: in dropdown boxes, we were able to double
click an item in a dropdown box to select it using
OLEOBJECTS. As we change to Office XP (Excel 2002), one
problem occurred: now, the very same action wouldn't be
able to select any item from the dropdown box, and there
was NO error message at all. It seems that the program,
for some unknown reason, skips the OLEOBJECTS. Any one
has the similar experience or knows the back-end of Excel
2002? Is there any change in terms of OLEOBJECTS from
Microsoft when their upgrading from Excel 97 to 2002?

..InsertLines .CountOfLines + 1, " strSection =
ActiveSheet.OLEObjects(""OurList"").Object.List
(ActiveSheet.OLEObjects(""OurList"").Object.ListIn dex,1)"

Thanks all!

What your code shows is adding code to a procedure. Not sure what that has
to do with the problem described. Unless you are placing your combobox
dynamically, there really shouldn't be a reason to write code dynamically to
get the selection.

--
Regards,
Tom Ogilvy



HELENA wrote in message
...
We have got an Excel/VBA application working very well
with Excel 97: in dropdown boxes, we were able to double
click an item in a dropdown box to select it using
OLEOBJECTS. As we change to Office XP (Excel 2002), one
problem occurred: now, the very same action wouldn't be
able to select any item from the dropdown box, and there
was NO error message at all. It seems that the program,
for some unknown reason, skips the OLEOBJECTS. Any one
has the similar experience or knows the back-end of Excel
2002? Is there any change in terms of OLEOBJECTS from
Microsoft when their upgrading from Excel 97 to 2002?

.InsertLines .CountOfLines + 1, " strSection =
ActiveSheet.OLEObjects(""OurList"").Object.List
(ActiveSheet.OLEObjects(""OurList"").Object.ListIn dex,1)"

Thanks all!

yes, while we double click an item in the dropdown box to
select the item, it is associated with queries talking to
middle tier COM objects or database using Oleobjects(?).
The problem we have is that we are unable to double click
an item in the box to select it though the items have been
populated in the dropdown box (we were able to do it WITH
THE VERY SAME CODE in Office 97). What happened to Office
XP?

helena

-----Original Message-----
What your code shows is adding code to a procedure. Not
sure what that has
to do with the problem described. Unless you are placing
your combobox
dynamically, there really shouldn't be a reason to write
code dynamically to
get the selection.

--
Regards,
Tom Ogilvy



HELENA wrote in message
...
We have got an Excel/VBA application working very well
with Excel 97: in dropdown boxes, we were able to double
click an item in a dropdown box to select it using
OLEOBJECTS. As we change to Office XP (Excel 2002), one
problem occurred: now, the very same action wouldn't be
able to select any item from the dropdown box, and there
was NO error message at all. It seems that the program,
for some unknown reason, skips the OLEOBJECTS. Any one
has the similar experience or knows the back-end of
Excel
2002? Is there any change in terms of OLEOBJECTS from
Microsoft when their upgrading from Excel 97 to 2002?

.InsertLines .CountOfLines + 1, " strSection =
ActiveSheet.OLEObjects(""OurList"").Object.List
(ActiveSheet.OLEObjects
(""OurList"").Object.ListIndex,1)"

Thanks all!





.