2 questions

I have two questions.

How to link a textbox in VB to a cell in Excel?

How to format a textbox in VB like how Excel format a cell. If I format it to have percent sign, it will always have percent signs.

Thanks...

Format a textbox to have a %
Use a label beside the textbox with a caption of %
or Text1 = % & "whatever you put in it"

Thanks but is there a method to automatically format like excel's cell?

I am doing the formatting in the Lostfocus event for now but like to know a better way.