RobExcel
RobExcel

Reputation: 191

VBA Userform with DTPicker

Trying to make a Userform which has three inputs; Name (via txtbox), a combo-box-choice-menu and the DTPicker, which is giving me trouble.

I'm having trouble finding the error in this code, for some reason it keeps giving me a compiling error.

Screenshot added: VBAProblem

Upvotes: 1

Views: 9484

Answers (1)

SierraOscar
SierraOscar

Reputation: 17637

DTPicker requires MSCOMCT2.OCX which is no longer native to the OS since Windows 7. It would make more sense to re-think your design, as your end users will more than likely require this library too before it will work.

There is an alternative Date Picker control developed by Roy Cox that doesn't require this library which can be found here

Upvotes: 1

Related Questions