excel - Accessing Hyperlink file explorer using VBA -

i creating spreadsheet act central point of documentation relevant project, quotes, drawings etc in single excel document hyperlinks files along information them. (e.g. drawing, drawing name , number requested)

i want through userform in order ensure sufficient information supplied referenced during audits.

but having difficulty hyperlink part there may not known address/name allows me use hyperlinks.add method.

what optimal ability click hyperlink button on ribbon inside userform.

this first time asking question, been trawling through stack overflow while though. open suggestions asking better questions etc.

cheers.

append hyperlink list using insert hyperlink dialog

private sub btninserthyperlink_click()     range("a" & rows.count).end(xlup).offset(1).select     application.dialogs(xldialoginserthyperlink).show end sub