Store an action to remember later

[PFDave]

Hi,

Struggled to think of the best way to title this but hopefully I can explain clearly.

I have a file where users are taken through steps by clicking on shapes on different sheets.

There will be instances where a user can continue with the usual steps, however if they select NO to certain questions (or click a certain numbered shape) I want to be able to remember that for when they reach the final step where I will either display a MsgBox or direct them to another replica slide but with slightly different wording.

Can this be done? Or what are peoples thoughts on this?

Essentially the situation is to try to fix the issue yourself, but if you can't connect the system you need to in order to fix the issue, you carry on trouble shooting with someone on the phone and then once you reach the end you then need to follow some steps to get yourself to connect to the system for next time. (the reason this isn't done at the time, is because it takes 20 minutes to complete and the issue they are trying to fix is a higher priority so must be done first)

Regards

Dave

[EssoExplJoe]

Store their answers to each step in an array of types:

Type
StepNo as integer
Answer as string
End type

[PFDave]

Thanks for the input Esso.

Could you elaborate on this please with an example?

Thanks again

[EssoExplJoe]

Just dimension an array of the types;

Please Login or Register  to view this content.

After each step is completed, set the step answer in the array. You can save the array to a worksheet after each answer if you want under a username, etc..

[PFDave]

Thanks Esso,

But could you provide a working example, I've never used type before or usernames in excel, but this sounds exactly like the kind of thing I would like to use.

Thanks again

[EssoExplJoe]

Define the user type:

Please Login or Register  to view this content.

When the user restarts a session, get his user name and date of original session then get his answer record:

Please Login or Register  to view this content.

Update the answer record each time the user answers a question;

Please Login or Register  to view this content.

This will give you an idea of how to use user defined types.

[PFDave]

Thanks Esso,

give me something to work with for sure.