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

Ryan,
You are in the VBA IDE ? Not on a Excel worksheet ?

NickHK

"Ryan" wrote in message
...
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?