Excel VBA userform line of questioning.

[naviwins]

I have an excel document that has 5 successive cells on 1 column that need to be filled in with data. I am looking to create a VBA userForm that will go through a line of questioning to help the user input the correct data.

Lets say that the 5 cells are A1 through A5. Once the userform is called it should show a question(label maybe?), A text box for the input of data, and a command button to move on the the next question. all the while moving from A1 to A2 and so on until the line of questioning is done.

Does anybody have any idea how to accomplish this? My VB knowledge is basic but i have tried and tried to no avail.

Thanks in advance!

[Solus Rankin]

Will the textbox entries for every person be the same format? Will it depend on the user? Is there such thing as a "wrong" answer to the questions? Are the answers supposed to overwrite old entries?

[naviwins]

I have been trying to get this to work, to my understanding it is exactly what i want but i can not seem to have it work properly.

Please Login or Register  to view this content.

[Solus Rankin]

Can you attached a sample workbook?

[naviwins]

workingLOQ.xlsm

I got it to work.

If anyone needs something like this it is pretty nifty.