Hello,
I use excel in the very simple way that most home users do so you can
imagine the limits of my capability, so please accept my apologies in
advance for misuse of terminology.

I am creating a spreadsheet for our athletics club and would like to
apply a spinner to a cell in order to toggle through a short list of
options to display.

I have managed to find the spinner button.
I cannot understand the help files when it comes to linking this
spinner to data and a cell.
At the risk of beeing a pain, a simply-worded set of complete
instructions would be greatly appreciated.
Thankyou very much for your time.

regards
John


--
justjohn
------------------------------------------------------------------------
justjohn's Profile: http://www.excelforum.com/member.php...o&userid=30663
View this thread: http://www.excelforum.com/showthread...hreadid=503278

Why not use Data Validation. See Debra's site for a starter
http://www.contextures.com/xlDataVal01.html

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"justjohn" wrote in
message ...

Hello,
I use excel in the very simple way that most home users do so you can
imagine the limits of my capability, so please accept my apologies in
advance for misuse of terminology.

I am creating a spreadsheet for our athletics club and would like to
apply a spinner to a cell in order to toggle through a short list of
options to display.

I have managed to find the spinner button.
I cannot understand the help files when it comes to linking this
spinner to data and a cell.
At the risk of beeing a pain, a simply-worded set of complete
instructions would be greatly appreciated.
Thankyou very much for your time.

regards
John


--
justjohn
------------------------------------------------------------------------
justjohn's Profile:
http://www.excelforum.com/member.php...o&userid=30663
View this thread: http://www.excelforum.com/showthread...hreadid=503278