Drop Down Button

[young engineer]

Hi All
I want to add a drop down/slider for a particular cell, with a range from 0 to 14, in increments of 0.1.
I am using excel 2007.

 

[MickG]

Hi, This is a scrollbar (slider) Control from the "View", Toobars", Control Toobox" Menu.
There may be other ways to do this, but this worked for me.
You can do this with or without a userform.

Private Sub ScrollBar1_Change()
ScrollBar1.Min = 0#
ScrollBar1.Max = 140#
ScrollBar1.SmallChange = 1
[b1] = Format(ScrollBar1.Value / 10, "0.0")
End Sub

Regards Mick

 

[Mark F]

Another option, make a list somewhere on your sheet of the figures you want in a dropdown

ie 0.1 in aa1; 0.2 in aa2 ; 0.3 in aa3 to 14 etc

Then for the cell you want the the dropdown in, use
Data>Validation>drop "Allow" down to list, then highlight you 0.1 to 14 range (0r use that Range's Name)

Not sure if that is completely clear but.................

Mark