Thanks, that will help with the 50 characters, now is there a way to get the
userform to automatically open when a particular cell on a worksheet is
selected? For arguments sake let's say Range("A1").

"Tom Ogilvy" wrote:

> Use the change event of the textbox to update a label and limit the number
> of characters. It fires on each key entry.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "jnf40" <jnf40@discussions.microsoft.com> wrote in message
> news:68F2A826-0ADD-4327-8ED1-5A9C4E7035CC@microsoft.com...
> > I want to create a userform that shows when a particular cell is selected
> on
> > a worksheet. Then I need a textbox also 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, like
> > something that shows 0/50 and as they type it would change 16/34. Is there
> a
> > way these actions can be done?
> >
>
>
>