Thanks all for your thoughts and insights.

So, xld, let me think through what your proposal is.

You are basicallly stating that a UserForm be statically set. Now, if I need to have dynamic data displayed (the data on the spreadsheet will change both in "Range" and in number of "Ranges"), that could be done programatically. Am I reading this correctly?

I would just need to set the UserForm to some size that could accomodate the various comboboxes, labels, buttons, etc. that could come up. Yes, I could adjust the spacing for viewablily and that would be OK.

So, keep me in tune of what could/coud not be done in this scenario.

I will have to weigh the advantages/disadvantages against what I have been asked to come up with.

My first thoughts were everything dynamic, but after what you said, some further mulling, maybe I am over complicating some of this.

Thanks again for your help and look forward to more insights and help.

E