On Sep 12, 12:57*pm, "Otto Moehrbach"
wrote:
Rachael
* * I have written a VBA driven file for you that does what you want, I
think. *At least it will get you started. *It consists of 3 macros in 3
different modules. *You said that you are not familiar with VBA so it
wouldn't help you for me to post the macros. *Send me an email and I'll send
you the file. *We can then go from there. *My email address is
. *Remove the "extra" from this address. *HTH
Otto"Rachael" wrote in message

...



Yes. This is what I want. I just don't know how to program the button to
do
that at all. I know nothing about programming (except basic HTML)....

"Otto Moehrbach" wrote:

Rachael
* * I can imagine something like this: *You have a hidden sheet with a
list
of all the clues, in order, in Column A. *In Columns B,C,D,E *you would
have
4 possible answers/passwords for each clue. *For each clue, one of those
answers is the correct one. *In Column F of this hidden sheet, you would
have the correct answer.
On the main sheet, the sheet that the user sees, you have the first clue
in
say, Column A. *You also have a button at the top with frozen panes
active
so that the button is always visible. *Next to the button you would gave
a
Data Validation cell.
The user clicks on the button. *A macro will then fire that will set the
4
choices for that clue as the list in the DV cell. *The user will then
click
on the down-arrow of the DV cell and will see the 4 choices. *He clicks
on
his choice. *The macro will then find the clue in Column A of the hidden
sheet and will check if the answer he gave matches the entry in Column F
of
the hidden sheet. *If it is, it will copy the next clue and paste it in
that
first sheet and will reset the DV cell with the choices for that clue.
If
his choice is wrong, the macro can display a message box telling him
whatever you want. *You might also want a "START" button to reset
everything
back to the first clue.
Does this sound anything like what you are looking for? *HTH *Otto
"Rachael" wrote in message
...
Hello. I want to set up a simple locked down spreadsheet for a treasure
hunt.
I want there the be an initial cell on the screen with a clue. I want
there
to be some kind of button where they can click and put in a
password/answer
and then the next cell will populate with the next clue.
I'm a novice user of excel - fine for basic tables and some forumlas,
but
that's it.
I need to make this spreadsheet for work for next week (so, finishing
it
this weekend for Monday) for International Talk Like a Pirate Day
(Sept.
19th). Thanks!!- Hide quoted text -

- Show quoted text -

Can you post the macro on here so we can try it too? In case it's
something we might have to do as well.

Thanks!