Macro is removing repeated characters from a cell

[ussenterprise]

Hello all, I have a macro that is sending commands to an open window.

If the cell contains a repeated character, it ignores all but the first character.

For example: add becomes ad.

If I change the cell to something that does not have repeated characters, it sends normally.

Any thoughts?

[edit]
Additional examples:
00 becomes 0. (This is an extreme problem!!!!)
... becomes .

[MarvinP]

Hi ussenterprise,

Are you using SendKeys? I'd put a DoEvents just after each SendKeys to allow the OS Keyboard handler time to process the information. If you don't wait a bit VBA just simply keeps sending then without the OS having time to deal with each keystroke.

[ussenterprise]

Hi MarvinP. No. I've not had much luck with SendKeys. I'm using a different macro set.

Please Login or Register  to view this content.

[ussenterprise]

You might be on to something here.... If I uncomment the Wait just before the loop, it appears to display correctly. Should I add a DoEvents as it's own line?

[ussenterprise]

Thanks MarvinP! This looks like it works. (1000s of lines, so kinda hard to check each one. I suppose the device I am pushing to will tell me if there's an error! haha)

[MarvinP]

Wow,

I'm so glad it works. I've struggled with DoEvents (on a line by itself) many times in the past. Another killer for me is working off the event of Change in a workbook or userform. If I type the same number over the old number the event of change doesn't trigger but it does if the number is different. Fools me every time. I also don't know if two DoEvents in a row might help allow the OS to perform its actions. This is like watching electrons flow out of a socket. You simply can't see or trace them as with DoEvents and why timing in VBA code sometimes works or not.