Slider Control

[bob3940]

I haven't developed in VBA for some time now and this is starting to drive me crazy. There used to be a slider control for choosing a value. (The most common use would be like the volume slider in the speaker settings.) I've used that several times in the past. I am now back on a programming project and for the life of me I can not find the control. It is not in the standard controls in my toolbox and if I look through my additional controls there are a bunch of Microsoft Forms 2.0 controls but not a slider. It used to be part of the Microsoft Common Controls dll but that is not available. I have rigged up a scroll bar to take it's place for now but would really like to use a slider if possible. I'm working in MS Office 2013 if that makes a difference.

Thanks.

 

[combo]

Microsoft common controls are a part of VB, not VBA. You can download components from

http://www.microsoft.com/en-us/download/details.aspx?id=10019.

The slider is in MSCOMCTL.OCX. Depending on licensing you may use those controls as developer or user only.

combo

 

[strongm]

>You can download

Technically, only under certain circumstances. Be very careful to read the Section marked 'Details' on the download page. In summary, if you are not a licensee for VB6 or VS6 then you should not download it (unless you already have older versions of the controls installed - which in this case would not appear to be the case - normally because they were redistributed with a properly licensed application; in this scenario you get a runtime licence for the controls, but not a design time license).

 

[combo]

Paralelly with vb6 microsoft issued free vb6 Working Model Edition, that had all common controls components. It can be still found in the web.
The real problem is that ms has not upgraded those components to 64 bit version and they do not work in 64 bit vba.

combo

 

[strongm]

The Working Model is only licensed to run programs within the VB6 Working Model IDE. That includes the various controls. You do not get the right to redistribute the controls (or programs, which you couldn't compile anyway), nor do you get a design-time license for use anywhere at all apart from within the Working Model IDE. And the Working Model was never free (just very cheap, since it was intended to be bundled with training books, such as Visual Basic 6 for Dummies). Only free edition of VB was the precursor to the Working Model, the VB5 Control Creation Edition (CCE)

>they do not work in 64 bit vba.
Indeed. And that's probably the clincher. Whether downloaded legally or ... er ... not so legally, none of the common controls will work with 64bit versions of Office. And in it's 32bit guise Office should install the relevant controls anyway, so no need for any not so legal downloads.