Show Dialog of File/Directory
you can't use Application.Dialogs to get the filename - it would just open
the file
use Application.GetOpenfileName()
Dim mypict as String
mypict = application.GetOpenfileName()
if mypict < "False" then
image1.picutre = loadPicture(mypict)
End if
--
Regards,
Tom Ogilvy
B Tuohy wrote in message
...
In a userform I would like to allow users to select what picture to
display
in an image control, and plan to use LoadPicture() to do it. Question:
What
is the dialog that I can use to get file directory information, as
follows:
mypict = Application.Dialogs(xlDialogXXXXXXXX).Show
Image1.picture = LoadPicture(mypict)
What is the xlDialog?
Thank you!
|