Is it possible to create somekind of slider selection control in Excel? I
want people to be able to choose answers to a question using a slider similar
to what you might see in questionaire with answers such as 'extremely poor',
'poor', 'neutral', 'effective', 'extremely effective', although mine will be
number ranges.

Try menu option (xl 2003) Data, then Validation and under settings tab allow
List. When the user selects the cell a drop-down list appears.
--
MacGuy


"smilee8_28" wrote:

Is it possible to create somekind of slider selection control in Excel? I
want people to be able to choose answers to a question using a slider similar
to what you might see in questionaire with answers such as 'extremely poor',
'poor', 'neutral', 'effective', 'extremely effective', although mine will be
number ranges.

Is it possible to create somekind of slider selection control in Excel? I
want people to be able to choose answers to a question using a slider
similar
to what you might see in questionaire with answers such as 'extremely
poor',
'poor', 'neutral', 'effective', 'extremely effective', although mine will
be
number ranges.

You could use a scroll bar on a userform.

http://www.rose-hulman.edu/~moloney/...readsheets.htm
http://www.math.ksu.edu/math100studi...m100slider.pdf

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"IanKR" wrote:

Is it possible to create somekind of slider selection control in Excel? I
want people to be able to choose answers to a question using a slider
similar
to what you might see in questionaire with answers such as 'extremely
poor',
'poor', 'neutral', 'effective', 'extremely effective', although mine will
be
number ranges.

You could use a scroll bar on a userform.