numeric up down tool on userform

[c.vaibhav]

Hi,

Do we have NumericUpDown Tool Control in MS Excel 2003 that can be employed on a userform. The one similar to the numericupdown of VB.NET.

I want to restrict user to input only numerals..

Though I can use IsNumeric Validation in Textbox_Change event but still I was curious to know if there is any other in-built function in MS Excel..

Regards,
Vaibhav

[dominicb]

Good morning c.vaibhav

Do we have NumericUpDown Tool Control in MS Excel 2003 that can be employed on a userform. The one similar to the numericupdown of VB.NET.

Yes, you can use a spinbutton. Set up a userform with a textbox (TextBox1) and a spinbutton (SpinButton1) and then use this code to see how the control affects the textbox :

Private Sub UserForm_Initialize()
TextBox1.Value = 1
SpinButton1.Value = 1
End Sub

Private Sub SpinButton1_Change()
TextBox1.Value = SpinButton1.Value
End Sub

There are other controls for a spinbox that can be set through the property window (Max / Min etc), or these can be set via code at run time.

HTH

DominicB

[c.vaibhav]

That worked..

thanks..