View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Shevlin Ryan Shevlin Ryan is offline
external usenet poster
 
Posts: 6
Default How to leave a combo box?

Wow, Bob, that was fast!

I pasted the code as you said. It works fine when going from the first
box to the second, but I get an error when going from the second to the
third. "Runtime error 1004. Unable to get the OLEObjects property of
the Worksheet class". Clicking Debug shows
"ActiveSheet.OLEObjects(ctlNext).Activate" highlighted in the "Private
Sub ComboBox2_KeyDown..." section.

It's probably something simple, but I have other things pressing right
now. I'll look at it later.

Thanks a million!



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!