Hello All,
Hope all the clever Excel people are well today. I have a bit of a conundrum, much like the chap in the post below:
http://www.mrexcel.com/forum/showthread.php?t=565618&highlight=Combo+box+selection+combo
It seems, no matter how much I search, I cannot find a straight forward way of achieving the goal of limiting the selection list of one combo box, based on what is selected in a separate combo box. Also, to make this more interesting, i would like to know a way of doing this with VBA and also without VBA (so from a combo box in the worksheet).
Thank you so much for your help in advance. I know someone will know!
Regards
Ughes
Hope all the clever Excel people are well today. I have a bit of a conundrum, much like the chap in the post below:
http://www.mrexcel.com/forum/showthread.php?t=565618&highlight=Combo+box+selection+combo
It seems, no matter how much I search, I cannot find a straight forward way of achieving the goal of limiting the selection list of one combo box, based on what is selected in a separate combo box. Also, to make this more interesting, i would like to know a way of doing this with VBA and also without VBA (so from a combo box in the worksheet).
Thank you so much for your help in advance. I know someone will know!
Regards
Ughes
