Double quote entry in textbox causing runtime error 1004

[TheWordsmith]

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.

Any help would be much appreciated!

 

[TheWordsmith]

Update: I discovered why copy+paste does not cause a crash. Copying from MS Word copied Word's quote mark which uses ASCII code 148 instead of the ASCII code 34 character that is used when typing in the Userform textbox.

However I'm still not sure how to make this work when typing. I would rather not require users to copy+paste from Word every time