Scratch the follow on, I have found the answer, it was in the reference you
gave me! Thanks very much!

"AndyRoo" wrote:

Helpful reference thanks! I am still struggling to get it to do what I want
as slickly as I'd like though.
Do you know whether there is code instruction I could write to say 'when
user selects item from combo box 1 then do x, y & z' I know the x,y&z I want
it to do, I just don't know the code to prompt it to go and do it.
I hope that isn't clear as mud!

"Toppers" wrote:

Look at Data Validation - creating dependent lists:

http://www.contextures.com/xlDataVal02.html

HTH

"AndyRoo" wrote:

I have a user form that requires 2 choices to be made, currently using combo
boxes for both.
I would like to make the choices 'smarter' though such that the choice
selected in the first combo box drives the choices available in the second
combo box.
I have 9 possible choices for the first combo box, each each of which should
have 3 to 9 possible choices listed in the second combo box, these choices
are in 9 separate rows in my data sheet.
So far I haven't figured out how to do this so the second combo box has been
set to refer to a 10th row source in which I have copied all the possible
answers for all the choices that could be made in the first box.
Any suggestions for a way to achieve this, I am not a slave to combo boxes
if there is a better option. I need it to be flexible so the user can change
their mind about the both choices before finally moving on though.