Modifying Spin Button

[MasterThrone]

Hi Guys,

Im Throne, I just learned the Min Function few days ago for an availability control and monitoring. So I figure why not use the spin button to minimize keyboard usage, make it cooler just like those brand application developer, and cause I like to click things. The spin button will function to add the nominal figure from D4 to D7, while it works wonderfully, I got the problem of to modify the position of the spin button from vertical to horizontal, which makes it less cooler. So kindly advise on how to rotate the spin button of the form control or if it is possible, I would like to put 2 different button in between the number for example < # > or - # + (the <> and -+ are the buttons, the # is number). By clicking one of the button will add or decrease the amount by one just like spin button of the form control. Thank you and kindly advise

Below is the sample of the table.

	B	C	D
1	Car	Produced	In Progress
2	Car A	1	4
3	Item	Amount	Need to be produced
4	Chassis	3	1
5	Body	2	2
6	Tires	1	3
7	Engine	4	0

[mordred111]

Quick and dirty method for 'horizontal' spin buttons on a UserForm

Step 1:

a) Use a blank worksheet and turn grid lines off
b) Insert Shapes : two horizontal triangles back to back and close together
c) Drawing Tools align and group the triangles
d) Copy result to clipboard

Step 2

a) Insert a new Userform
b) Add a Label control
c) Rename Label to Spinner_Label
d) Set Background style of Label to transparent
e) Use Picture Property of Label to insert image currently held on clipboard
f) Adjust size of Label to give as close a fit as possible

Step 3

a) Select MouseDown event for Label and enter:

If X >= Spinner_Label.Width / 2 Then
Call spin_up
Else
Call spin_down
End If

b) Set up the two handlers :

Sub spin_up()
MsgBox "Stuff resulting from incrementing the Spin Button"
End Sub

Sub spin_down()
MsgBox "Stuff resulting from decrementing the Spin Button"
End Sub

You will obviously need to customise these for your specific needs

Hope this helps


Mordred