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:

Private Sub InsertHyperlinkCommandButton_Click()

Dim emptyRow As Long
        
    'Make Sheet1 Active
    Sheets(1).Activate
    
    'Determine emptyRow
    emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1
       
    'Export Data to worksheet
    If Application.Dialogs(xlDialogInsertHyperlink).Show Then
    Cells(emptyRow, 5).Value = "Resume"
    End If

End Sub

& 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