Saving text in a user form

[Peter100]

I must be missing the obvious, But.

I have a user form with a text box for the user to enter notes. How do I make it save those notes entered as each time the user form is activated the text box is empty

 

[Legacy 98055]

It depends on what version of Excel you are using. 2002+ is limited only by the amount of memory. Unless you are storing a novel or something you probably won't have any problems. If so, split it up into as many names as you wish...