Shevlin,
It was fast as I keep a library of useful code, so all I hade to do was copy
and paste (and test a bit)<vbg
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Shevlin Ryan" wrote in message
...
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!