Hi,
I'm hoping someone here can help.
I have an Excel Spreadsheet with a UserForm. When data is entered in the textbox, a commandbutton is enabled that will allow me to go onto the next form. However, if I enter a line of text, hit enter, then enter another line of text, the form freezes. I can hit control-break to step through the code, after stepping through the code twice, the button will then become enabled.
The data is transferring to the spreadsheet without an issue.
I have MultiLine and EnterKeyBehavior both set to 'True'.
I'm using Excel 2007.
The problem only occurs when there are mutliple lines of text.
Here is my code:
Thank you
Bookmarks