Here is what I want to do,
I have a report form for my volunteer fire department, and at this time it has five different sections three of which are only necessary on certain calls. There is a basic information section, a section to fill out if it was a structure fire, a section for vehicle #1 and another for vehicle #2. I will probably make it more in depth later, but for now, I would like to be able to hide/unhide the unneeded sections based on the first cells input which is the type of call being reported. Especially on the vehicle sections, I would like to have a userform to pop up if the user inputs that it was a motor vehical accident. That I know how to do but I don't know how to go from there. I had thought about hiding/unhiding rows based on the userforms' input. The user form would either with check boxes or with a text box know how many vehicles were involved and unhide the necessary sections ie. one car = one section, three cars = three sections each looking alike except having veh #1, 2, 3, before them. Am I thinking right or is there perhaps a better way to do what I am wanting to?
I tried to make this clear, but if you don't understand, ask and I will try to clarify.
Thanks
Bookmarks