Didn't seem to work for me what I'd like is the ability to not to have to
actually drop down but to select it and use the arrow key down
like I can do in Control Settings, Display things,
if that is possible. Specifically as soon as I change the selection
the display must change. Otherwise would need that box to tell me
what I'm actually looking at.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"keepitcool" wrote in message ...
Scrolling in advance of change is a bit weird, perhaps you could
add Text on the bottom right to indicate what range
you are actually looking at.

Solved it...

cbo.SetFocus
SendKeys "+{TAB}{TAB}{F4}"


keeps focus, keeps it dropped down and doesn't scroll..