I have a form that allows a user to do some simple data entry typing names for example.
If I paste a name from another spreadsheet instead of typing it, the form result is different. Why?
....more detailed explanation...
When the user completes the data entry on the form and hits save, the code takes the items on the form and inserts them loops through the items on the form and adds them into the next empty row in a named sheet.
This works fine if the items are manually typed in.
If any of the text box data is copied and pasted into the form (from another workbook for example) and the user hits save, instead of inserting the data into the named sheet as above, the code inserts the data into a different sheet. This only seems to happen in run time and not when stepping through the code.
Has anyone heard of this?
Thanks...
If I paste a name from another spreadsheet instead of typing it, the form result is different. Why?
....more detailed explanation...
When the user completes the data entry on the form and hits save, the code takes the items on the form and inserts them loops through the items on the form and adds them into the next empty row in a named sheet.
This works fine if the items are manually typed in.
If any of the text box data is copied and pasted into the form (from another workbook for example) and the user hits save, instead of inserting the data into the named sheet as above, the code inserts the data into a different sheet. This only seems to happen in run time and not when stepping through the code.
Has anyone heard of this?
Thanks...