Excel help. Complicated issue.

[iouu2]

I've been working on this for a while now and wanted to get advice/suggestions on proceeding from here on....

I have a sheet that is shared off a network to users in the company. Its for purchases. This is a locked sheet for users, only letting them select from drop-down list and click check marks, purpose, as well as enter in values for unit price and quanitity.

The ideal goal : require users to select every option/fill in every detail before proceeding to next question.

Ideally, from the very start. To complete the form, the user must start from the very start selecting YES or NO then they can proceed.

In excel, is there a way where I could potentially block the entire page QUESTION by QUESTION. Keep in mind, its a locked sheet as is (so no formatting for users).

For instance, if you take a look at the screen shot, I wanted to generate a IF statements a long the way (probably working backwards) where the user has to select YES or NO then can proceed to #2 then #3 etc etc etc.

http://i56.tinypic.com/296lnk0.jpg

This file is a locked sheet for users so they can't format any of the cells other than selecting from the drop down and clicking on check marks.

The goal I intended was for the user to go step by step completing the form in its entirety.

 

[Kavy]

Only thing I can think of is conditionly formatting the future cells to only turn that teal color when the previous cells have data, wouldn't lock them out, but it would keep them on the correct path

 

[jvanbonn]

What if you created an array of the cells as they get filled in. That way they cant go forward until the size of the input array meets your criteria?

Just a though.

 

[ColinKJ]

Hi iouu2

I've put together an example WB called Control Input which you can download from:

http://www.box.net/shared/yuq77rxol2

there are only 3 inputs in this example, it is a protected sheet password "ckj".

Inputs 1 & 2 are dropdowns, and 3 requires a date.

if input 1 is not completed you can't go to either of the other fields, etc.

Is that what you're after.

 

[iouu2]

Thanks, that is exactly the type of set up I am in need of. I wanted to avoid macro's due to user resistance.



But that is exactly the type of coding I was in search of. Thank you all for your suggestions. I am going to play with that code and see if I can get the entire sheet to do the same.

Regards.