kittronald wrote :
Garry,

After using the updated code, when selecting a value in ComboBox1, the
VBE highlights the line "With Sheet2.ComboBox1" and displays the following
error:

Compile error:

Invalid outside procedure



- Ronald K.

Yeah, I wasn't trying to give you functional code so much as I was
trying to help you to understand the 'concept' of the code.

Replace: 'With Sheet2.ComboBox1'

...with: 'With Sheets("Sheet2'sNameGoesHere").ComboBox1'

I apologize for not spelling things out more explicitly!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc