Userform - Open word document/ hyperlink from populated text box

Hello chendysworld,

You can use the Shell command to open the file. If the path is in the text box then you could use...

Please Login or Register  to view this content.

Hello chendysworld,

Here is an example of the button code. You will need to open the Visual Basic Editor (Alt+F11) to edit the button's code. To display the button's code, double click on the button. Change the name of the Text Box to match the one you are using.

Please Login or Register  to view this content.

Hello chendysworld,

Here is an example of the button code. You will need to open the Visual Basic Editor (Alt+F11) to edit the button's code. To display the button's code, double click on the button. Change the name of the Text Box to match the one you are using.

Please Login or Register  to view this content.

Hello chendysworld ,

It would help me to see your workbook. There must be something else causing you problems with the code.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Hello chendysworld ,

I had to change from using the VBA Shell to using the API (Applications Programming Interface) ShellExecute to make this work properly. The attached workbook has all the changes shown here added to it.

The "Open" button on the UserForm calls the new macro and passes the value of TextBox1 to it.

Please Login or Register  to view this content.

The macro checks if the file to be opened is an Excel file. If so then it will open in the same instance of Excel and the active workbook. Otherwise, the file will be opened using the program associated with it.

Please Login or Register  to view this content.

Hello ,chendysworld

You can use the ShellExecute call to automatically open your default browser and go to the URL. Here is an example...

Please Login or Register  to view this content.

Hello chendysworl,

Copy the code below and paste it between the Sub and End Sub lines for your button. Change the name of the TextBox from TextBox1 to the name of the text box that holds the URL.

Please Login or Register  to view this content.

Leith, correct me if I am wrong but you need to put the following code in a standard module and write a valid URL in the textbox.

Please Login or Register  to view this content.

Hello chendysworld,

@abousetta - After opening the lateset workbook, the OP forgot to copy the macro, Yes, you are correct that it needs to made Public now instead of Private.

As pointed out, the macro had not been copied into the new workbook. I have added the macro and changed it to Public. The attached workbook contains the corrections and is working.

Hi there,
Maybe it's a bit late to reply to your query but I have found two ways you can open an URL within a TextBox.

1) Create a CommandButton (by clicking it, it will open the URL within the TextBox) as following:

Please Login or Register  to view this content.

2) By double clicking the TextBox to open URL:

Please Login or Register  to view this content.

I hope this helps.
Cheers.

Answered wrong post... Deleted response...