When i click the Hyper link The Dialog Box should populate

Hi All I am new to Excel vba.

In My project i have a hyperlink name " Click here to enter the Details"

When the hyperlink is clicked the Dialog Box Should Open. In that text box i have to

enter the Text.

How can i do it. I know how to hyper link to another sheet. But could any help

me when i click the hyperlink the Dialog Box should open.


How can i do it.

Thanks in advance

Thank you jetted. Thats i am looking for..