DialogBox
 

I would like to create my own UserForm with browse window.
How to do that?
I want to point(only, not open) at file in computer and then send its
path to program (as a string)
I dont know how to create my own userform with "browsing" window and
some more buttons to send this info further.
Thanks for help in advice.

DialogBox
 

Hi

Use something already built-in instead of creating a form:

Sub test()
Dim V
V = Application.GetOpenFilename
If V = False Then
MsgBox "chicken"
Else
MsgBox "Something with " & CStr(V)
End If
End Sub

--
HTH. Best wishes Harald
Excel MVP
Followup to newsgroup only please

"Greg" skrev i melding
om...
I would like to create my own UserForm with browse window.
How to do that?
I want to point(only, not open) at file in computer and then send its
path to program (as a string)
I dont know how to create my own userform with "browsing" window and
some more buttons to send this info further.
Thanks for help in advice.

DialogBox
 

Have a look at application.getopenfilename in the vb help.

simple use is

strFileName = Application.getopenfilename()

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in


"Greg" wrote in message
om...
I would like to create my own UserForm with browse window.
How to do that?
I want to point(only, not open) at file in computer and then send its
path to program (as a string)
I dont know how to create my own userform with "browsing" window and
some more buttons to send this info further.
Thanks for help in advice.