Excel VBA form is pasting text box data as symbols

Question

I have an excel VBA form that you enter data into and it spits it out into a text box in a certain format, then it copies it. This is so we can paste this data to multiple places for work. However one user on the server keeps pasting the data as symbols, little boxes with “<“ or “?” In them. It only happens sometimes but I have no idea what causes it. The form works fine for everyone else.

Answer 1

Hi,

If one user has problems with your Excel VBA form while others do not, the problem could be related to the user's system or Excel settings. Here are some methods to troubleshoot and fix this issue-

1. Check to see if the user's Excel or system has a different character encoding or language set. Characters can become garbled when copied from one encoding to another. Make sure that both the source and destination environments use the same character encoding.
2. Check to make sure the font used in the Excel VBA form is installed and accessible on the user's computer. When pasting, symbols or boxes may appear if the form uses a font that is not installed on the user's system.
3. When copying and pasting data, clipboard issues can happen. Ask that the user copy and paste the text into a different application (e.g., Notepad) to see if the problem persists. If it does, the issue could be with the clipboard or the user's computer.
4. Check for any Excel add-ins or third-party software that may be interfering with clipboard or text processing. Disabling such add-ins temporarily may help in determining whether they are causing the issue.
5. Check that the user is using an Excel version that is compatible with your VBA form. Compatibility issues can occasionally result in unexpected behavior.
6. Check to see if the user's Excel installation is up to date. Ask them to install any updates or service packs that are available.

Best Regards.