TheWordsmith
New Member
- Joined
- Aug 1, 2017
- Messages
- 3
Error message: Run-time error 1004: Application-defined or object-defined error.
Context: I have a userform with a textbox that I am using to enter data which is then written to a cell in an excel sheet. The problem I'm having is that when a quotation mark is entered into the text box it causes the above error on the line where the .value of the cell is set equal to a string containing the textbox entry. Note that this only crashes with a double quote, it works for other strings and even for single quotes.
Abbreviated version of the string that caused the crash: ... 1" charge line ...
Something interesting to note is that if I copy+paste into the textbox it doesn't crash, but if I type it in it does.
Context: I have a userform with a textbox that I am using to enter data which is then written to a cell in an excel sheet. The problem I'm having is that when a quotation mark is entered into the text box it causes the above error on the line where the .value of the cell is set equal to a string containing the textbox entry. Note that this only crashes with a double quote, it works for other strings and even for single quotes.
Abbreviated version of the string that caused the crash: ... 1" charge line ...
Something interesting to note is that if I copy+paste into the textbox it doesn't crash, but if I type it in it does.