Using Excel as a form that populates as you complete it based on your answers

[bobsmith123]

Hi All,

I hope you are doing well, collectively!

I just wanted to open a post about how one could leverage excel into a form that an end-user could complete with simple questions, primarily Y/N. Ideally, based on the users selection of Y or N additional questions would appear below the original question and so on and so forth. Is this something that could be done with excel? Something like this:

Question 1 would be:

Is this person a manager? (Y/N)
After the end user selects their answer, a second question pops up/appears below the original question. After the complete that one, additional questions appear below.

Is this doable?

Open to any ideas Gurus!

Thank you!
RJC

[ranman256]

you could do....

Please Login or Register  to view this content.

[zbor]

Try this version with unhiding rows on protected sheet

Password is: password

Only Y or N are accepted

[bobsmith123]

Hello,

I'm afraid I know nothing about the coding you provided Ranman, if it isnt vlookups I'm a bit of a fool with excel...

Zbor, I was not able to see anything update with your file. Is it possible to explain how I can create what you did on my side?

Please let me know.

Thanks All.

[zbor]

Enter Y in B column, next to question x

[ranman256]

record a macro
click a cell, stop the macro. (this will create a vba module)
edit the macro
overwrite that text with the code I sent above.
Edit the macro TakePoll and put in your questions.