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

[Rodney Roe]

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

[Guido Geurs]

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