Hello.
I have an Excel sheet named DATA and a text button with the word "TEST".
I want to assign a macro to that text button that opens a open file dialog, collect the the file name and replace the word "TEST" with the file name.
I've tried this:Sub TextBox4_Click()
Dim sFileName As String...