View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Common dialog control

Ryan,
Because you do not currently have a userform active.
This makes sense as you cannot add a control to a module or class.

NickHk

"Ryan" wrote in message
...
Nick,

Do you mean choose the Additional Controls from the Tools Menu in

Microsoft
VB editor?

I did so, but why the Additional Controls in the menu can not be click?...

"Ryan" wrote:

Nick,

your assume is correct.

Thanks for your advice.

I was trying to follow your instruction, I open the Control Toolbox and
right-click it, but there is no Additional Controls for me to click...

"NickHK" wrote:

Ryan,
I assume you are talking VBA in Excel and that you want to add a

Common
Dialog control to a user form.
For a control you do not add a reference but right click on the

ToolBox,
select "Additional Controls" and find your desired control.

Nick

"Ryan" wrote in message
...
Hi All,

Excel 2003 w/Visual Basic 6.3

there is no Common Dialog Box control in VB 6.3, when I try to

browse it
under folder system32 the files comdlg32.dll and comdlg32.ocx are

there,
but
I can not add it in the reference. The error messege is "can't add a
reference to the specified file". Can someone help me?