ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Assign a variables value to a TextBox (https://www.excelbanter.com/excel-programming/280591-assign-variables-value-textbox.html)

ed

Assign a variables value to a TextBox
 
I am using the application.getfile in the following
manner to send the selected applications path to a
variable. But I don't know how to send it to a textbox.


dim strpath as string

application.getopenfilename = strpath


Thanks
Edward


Tom Ogilvy

Assign a variables value to a TextBox
 
dim strpath as string

strPath = application.getopenfilename
Useform1.Textbox1.Value = strPath

--
Regards,
Tom Ogilvy

ed wrote in message
...
I am using the application.getfile in the following
manner to send the selected applications path to a
variable. But I don't know how to send it to a textbox.


dim strpath as string

application.getopenfilename = strpath


Thanks
Edward





All times are GMT +1. The time now is 12:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com