Combo/Toggle Box

[Tango53]

Can anyone help me find or create a combo-style box (with code) that has two small up/down bottons instead of the usual single drop-down selector? I'm thinking of the type of box found in MSWord's print dialogue box that's used to select the number of copies to print. I want to use this on a receipt form for selecting quantities of each supplied commodity.
Many thanks for your help!

 

[khawar]

You can make it yourself creat a text box then creat 2 button and add picture to them instead of text on click of button you can change the value in text box

 

[missinglinq]

As Khawar suggested, place a textbox on your form, in this example it's called TextBoxName .

Now goto Insert - ActiveX Control

Scroll down and select Microsoft Forms xx.x Spin Button

Then use this code

Private Sub SpinButtonName_Updated(Code As Integer)
 Me.TextBoxName = Me.SpinButtonName
End Sub

The Defaults for the Spin Button are

Min 0
Max 100

but you can change this by selecting the control then going to Properties - Other and setting them to the needed values.

Now the textbox value will Increase/Decrease with use of the arrows.

 

[Tango53]

Brilliant,

Thanks missinglinq and khawar,

I just found the SpinButton control and was wondering how to utilise it! I'll give your suggestion a go later and let you know how it goes.

Cheers and thanks again,

T.