Common Dialog Box doesn't show up
In Excel, I tried to add a Common DIalog Box (to select files).
In Design Mode, I opened a new User Form and added a Commom DIalog Box.
In code, I entered the name of the Dialog Box and added : .ShowOpen
I tried to degub (F8) the code. The Dialog Box doesn't appear.
PHP Code:Option Explicit
Private Sub frmChoose_load() 'This is the Form on which I loaded the Common Dialog Box
cdbFileChoose.ShowOpen 'This is the Common Dialog Box I wish to see
End Sub
Last edited by szabo; 04-23-2008 at 08:12 PM.
Please edit your post to add code tags.
Why do you want the Common Dialog box/ Can't you use the standard controls like a textbox?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Text Box does work! Thanks
I still wonder if there is a way the Common Dialog Box can be used. But now it became a secondary issue.
Thanks.
many of the additional controls available can be difficult to work with and/or cause problems because they are not available on all computers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks