Common Dialog Error

[Clement]

Hi all,

I trying to add a commondialog control into my VBA form in excel, but it
show an error message "The control could not be created because it is not
properly licensed."

How to solve this problem?

Thanks

Clement

 

[Chip Pearson]

Clement,

You need a design-time license for the CommonDialog control, which comes
with VB6 and, I think, the Developer edition of Office. ActiveX controls
operate in two "modes": RunTime and Design. If you have the control on your
machine, you can use it from compiled programs at run time. But in order to
include the control in your own projects, you need a design license.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com