for loop to accept values

[jmevius]

I am currently working on an Excel file that estimates time to assemble a unit. I would like to include a combination of yes/no buttons and a for loop to accomplish one section but can't figure out how to implement.

For example, on the question and answer form, a question might read:

"Does the unit have parts with multiple interfaces?" with Yes/No buttons beside them.

If Yes is pressed, I would like unhide a cell that asks how many parts with multiple interfaces are on the unit.

Then I would like to unhide enough rows to ask how many interfaces each part has.

For example, if there are 4 parts with multiple interfaces on a unit, I would like to unhide 4 rows. The first row would ask how many interfaces part #1 has. The second row would ask how many interfaces part #2 has, etc.

I could guarantee a maximum value, like there would be no more than 15 components.

Any ideas how this could be easily implemented for a non-Excel-guru?

Thanks,
Jason

 

[Al Chara]

Ever thought about using a userform with dynamic numbers of texboxes instead of hiding and unhiding rows in a worksheet? Do a search on this board for dynamically adding controls.