web query when data entry

[Zack L]

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!

 

[Don Guillett]

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

 

[Zack L]

Sure, it is www.officedepot.com

Thanks much!

Z

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

Would you care to be a bit more specific. I would imagine its a large site.