Custom Userforms
 

I want to create a userform that shows when a particular cell is selected on
a worksheet. Then I need a textbox to on the userform that will only allow 50
characters to be entered, and I would like to be able to show the user how
many characters they have used while they are typing in the text box. Is
there a way these actions can be done?