Pass Row and Column Number Index To Refer And Put Value To Cell Range

[bakerman]

Why 5 Userforms (and more to come) ? This can all be done with one single userform.
This way you are not headed towards a programmatic disaster when everything is up and running.
One form, 3 CB on top for Campus - Building - Room and 3 frames or multipages for Walls - Floor - Ceiling and you're done.

[wscottd]

Thanks Bakerman & ExcelFox Admin

I agree, and the consensus is, the first run at this is definitely not the way to go and will make the project overly complex. I will go back and restructure the project.

Thanks again for the advice, it is quite helpful for getting things started in the correct direction.