Creating a reusable form...

Hey Guys,

I have been having a hard time trying to figure out a solution to this problem, and I think it has to do with my lack of excel knowledge, so I was hoping the community here might be able to give me hand.

I have created a form, using drop down menus and text boxes for a client to fill out electronically. The form works decent enough, problem is, for this application the client will need to complete a few hundred of these, all the fields will remain the exact same for each form, only the title at the top of the form will change. This is where I'm running into a problem, I don't want to copy the form onto a few hundred sheets, that would make it very cumbersome to use, and I can't just copy the form multiple times since scrolling to say the 112th would be a pain (and it would look ugly). I was hoping there would be a way to maybe have a drop down menu and the ability to select which form to display. I know that sounds more like a Microsoft access application, but I do not have 'access' to that software.

Any advice or tips you have would be great.

Thanks!

Thanks so much Marvin, that tutorial worked great. I had a lot of fun using VBA (first time), I think I understand it much better as well.