User Form - Hyperlink Button within a Form, to create a Link on a Designated Cell

Hi,

Introduction:
I have just started using Excel VBA and am slowly learning the program for a project at work, using online tutorials, watching Macros being recorded and this really helpful forum.

However I need help, as I can not get my head around how I should do the following:

Issue:
I am currently creating a user form in which an individual can type in several variables and at the click of a button, the software, will paste the information on to the spreadsheet.
However I want to be able to create a command button within the user form that when clicked will:

1. Input a text, e.g. "Resume".
2. Prompt the Hyperlink Dialogue Window to Appear.
3. Individual selects appropriate document and clicks 'OK'.
4. When Individual closes the user form, the next available empty row and cell is populated with the text "Resume" and the corresponding Hyperlink.

Current Solution:
Currently for the 'Hyperlink Command Button' within the user form, I have utilised the following Excel VBA code:

Please Login or Register  to view this content.

& The following happens:

1. User clicks the command button - 'InsertHyperlinkCommandButton'
2. Text value of "Resume" inputs itself on the next available empty row, on column 5.
3. The Hyperlink Dialogue Window Appears
4. User selects their required document and clicks 'OK'
5. Hyperlink is created but on the last highlighted cell, not on the next available empty row, on column 5.

I think that the reason why the hyperlink is not being pasted on to the required cell is down to the 'Export Data to worksheet' part of the VBA code. However I can not figure out what I should be typing instead.

Other:
I have attached an example worksheet of the VBA Code that I have shown above in working practice, below, as I am restricted on not being allowed to upload anything to do with work.
Example - Userform.xlsm

Thank you in advance.
Sinalk

as the dialog applys the hyperlink to the active cell try making the relevant cell active first

Please Login or Register  to view this content.

You example shows mailto hyperlinks for each email address. If that is the case you can probably do away with the dialog.