Make text boxes in userform visible based on a value in another text box

Hello,

I have a couple of userforms that I am playing with, to try and make an idiot proof, tried other ways but have been proven wrong.

From the general info userform I have it set so that when enter is clicked it enters the data and opens the second user form. I am trying to get the second form to only show the number of boxes based on the value in the number of courses box, so if it is 4 then 4 show up, if it is 6 then 6 etc.

- First User Form

Capture.JPG

- Second User Form

Capture.JPG

Give the attached a try.

Please Login or Register  to view this content.