We have this line in our codes for entering parts of a formula:
TestObj.Keys(ELSE IF t ge G THEN)
However, the script has been entering "ELSE IF T geG THEN" on a number of times lately, and I'm not sure why. It's missing the space just before 'G' in the formula.
Does anyone know why this is happening? What can I do to improve the reliability?
I've seen this happen with auto complete on some forms. Does the control support auto complete? You could use set text as Robert suggests as well. I prefer to use .Keys because it more accurately represents what a user will do.
I've seen this happen with auto complete on some forms. Does the control support auto complete? You could use set text as Robert suggests as well. I prefer to use .Keys because it more accurately represents what a user will do.