Use a worksheet_change event
If you give the url etc, I will try to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Zack L" wrote in message
...
Hi, how do I cause a web query to execute when I enter data into a
particular
cell? i.e. when I type an item code into the cell, the query goes to a
vendor web site and retrieves its price, name, etc. thanks much!