Userform Control

[tianimo]

Hi,

does anyone know if Excel VBA Userforms are supposed to contain a "countbox" of some description as a standard (or 'additional') control for Userforms?

I've looked through the Toobox menus, and can't seem to find anything. It's certainly not one of the standard Microsoft Forms 2.0 controls provided with Excel 2003.

Perhaps I'm going crazy, but I swear I've seen it on someone else's version of Excel. It looks a bit like a spinbutton and a textbox displaying a number combined, except it's just one object.

Thanks

tianimo

 

[kevin.philips]

Hi,

I can't find it anything on my machine that represents a single control that you seek, it is however very simple to code:

On a form place:

1 scrollbar (Named ScrollBar1)
1 Label (Name Label1)

In the code window for the form place the following:

Private Sub ScrollBar1_Change()
Label1.Caption = ScrollBar1.Value
End Sub

HTH

Regards

Kevin

 

[DominicB]

Good afternoon tianimo

From the VBE go to Insert > UserForm. On the blank userform draw a textbox and a spinner. Now hold down Ctrl, select them both and drag them onto the Toolbox. Every time you open Excel this additional tool will be available and will set them both up at once if dragged onto the UserForm. Of course you'll have to reference them seperately when coding but that's not that difficult.

HTH

DominicB