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...