create hyperlink in userform textbox and shift to a next blank cell

[obaid_457]

Hello Friends
I have a user form
with
Textbox1
CommandButton1
CommandButton2


I want to type a name in textbox1
then with CommandButton1 I want to attach hyperlink with

Textbox1​

text
and with

CommandButton2​

I want to add that text with hyperlink on next Blank Cell in sheet

will some on help me??