numeric up down tool on userform

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

Good morning c.vaibhav

Originally Posted by 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 :

Please Login or Register  to view this content.

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