Internet Explorer not validating dropdown list commands given by VBA script

[siddharth1980]

I am working on populating a website with exceLVBA code that runs with a command button and pulls data from Excel cells.

Two points-

1> A part of the code is when a person selects his state. say Arizona on excel combo box , the code below executes and selects AZ - Arizona in the internet explorer page which is a drop down list.

ie.document.getElementById("$idofdropdownlist").Value = "PBC|US|AZ"

An undisclosed button which is initially disabled is enabled by code ie.document.getElementById("undisclosed").disabled = False
The button is clicked using this command ie.document.getElementById("undisclosed").click, which interact with underlying database and executes an event but gives an error that " the value in state is required for search".

It seems IE is not identifying the entry of the state field.

2> Not always but sometimes I get an error "Object variable or Wih Block Variable not set" for following code which fills in a text box.

ie.document.getElementById("textbox").Value = "creation request"


Please give me a solution for 1 and 2

[Norie]

Can you post all the code and the URL?

[siddharth1980]

I may not be able to code tags.

[Norie]

Can you add code tags?