By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,584 Members | 1,750 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,584 IT Pros & Developers. It's quick & easy.

How to bring a commond dialog control into my user form?

P: 61
I'm using excel 2007 vba.

I'm trying to use a commond dialog control in my user form, but it says that I don't have a license for it. Yet I can select it from the additional controls list.

I have a userform from Guido Geurs that I can add the control to, but when I create a new userform on a new worksheet it won't let me. Why will it let me on one but not the other? Any ideas on how I can fix this? From my reasearch I found that installing vb will fix the problem, but I don't have that option with this computer. I don't have vb installed on this computer.

thx
RRR
Feb 8 '11 #1
Share this Question
Share on Google+
1 Reply


Guido Geurs
Expert 100+
P: 767
There are different reasons: not registered, ... (see web: google for "vba No license to use this functionality").

Found also this:

There's a bug in VB5's and VB6's that prevents license
information for controls included with VB from getting written into the
Registry if a later version of that control already exists (the bug is since
VB's Setup doesn't install the file it also doesn't write the license
information).

PRB: "License Information for This Component Not Found" Error
http://support.microsoft.com/kb/177799/en-us
Feb 10 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.