Excel VBA - IE Automation Form Trouble

[mugginsjr]

I'm using Excel VBA to control IE - more specifically a javascript multi-page form with several text boxes and other elements such as drop down boxes. The drop-down boxes and multi-select boxes have an "onchange" event that I am successfully firing. And I am able to fill the text boxes out too - but when reaching the last page of the form and clicking "submit" it's like the text boxes were never filled out and they are now empty.

About a month ago I ran across an answer where the respondent said that some javascript code can detect whether a key was pressed or not - and he provided a fire event solution that works around it - but now I can't find that answer anywhere.

I suspect that might be my problem. Can anyone tell me what the work around is to fire this sort of key pressed event?

 

[John_w]

If you're using IE9 or higher, have you tried dispatchEvent instead of fireEvent "onChange"?

See http://www.mrexcel.com/forum/excel-...even-after-fireevent-command.html#post4121317 for a similar problem. Tip - don't click the link to the solution in that post because then the solution is hidden; instead Google "VBA+IE9 FireEvent ("onchange") doesn't work" and the answer is the first search result.