Inserting text from Excel to Internet Explorer into a inputbox with a Input mask

[adibakale]

I have written a macro that sends text from excel to an input box on a website to be used as for a search. The code works fine for other textboxes, however this textbox is giving me issues. It seems that it is inserting the text as a input mask instead of the actual value.

Here is my VBA code that inserts the text:

.getElementById("[I]element_id[/I]").Value = ssn

Here is the inputbox that i need to put the text into:

<input name="element_name" class="quickSearchType" id="element_id" onkeydown="if(event.keyCode == 13){document.getElementById('element_id').click(); return false;}" onfocus="javascript:QSGotFocus();" onchange="javascript:QSChanged();" type="text" size="20" value="Enter SSN...">

When I click in the input box then run the code, it seems to work. I am thinking that I need to set focus to the textbox before adding text, but not sure how to do that.

Right now, when I run the code, it shows a greyed out text/input mask instead of the actual value.

 

[John_w]

I am thinking that I need to set focus to the textbox before adding text, but not sure how to do that.

Try:

.getElementById("element_id").Focus

Or look at FireEvent (<=IE8) or DispatchEvent (>=IE9). That's all I can suggest without knowing the URL and being able to access it.

 

[adibakale]

Try:

.getElementById("element_id").Focus

This worked - thank you!