ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is somekind of Slider Selection possible? (https://www.excelbanter.com/excel-programming/429098-somekind-slider-selection-possible.html)

smilee8_28

Is somekind of Slider Selection possible?
 
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.

MacGuy

Is somekind of Slider Selection possible?
 
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.


IanKR

Is somekind of Slider Selection possible?
 
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.


ryguy7272

Is somekind of Slider Selection possible?
 
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.




All times are GMT +1. The time now is 12:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com