Run macro when formula results changes based on different input cell

Hi all together,

I'm pretty new to vba and my knowledge is less than basic. However i've been able to successfully create a macro which automatically runs when cell value changes (by manual input/enter). But I need to change something but get stuck.

What I need is either the macro runs when cell "city" changes based on a formula (other cells are input) or, that city is changed manually but in the line IE.navigate "http://://www.zillow.com/" & Range("city").Value it will complete the URL based on another cell.

Hopefully you understand my problem and have a solution. Thank you very much in advance,

David

Here is the macro:

Please Login or Register  to view this content.

Put your code in [CODE] tags. Does that code actually open up internet explorer? It doesn't do that for me and I don't know how to open outside applications from excel.

Hmm...I think I was not clear Well the code works well, it opens internet explorer but you don't notice (invisible). however, so far it only works if my input is in "city" which will look exactly like e.g. "San-Diego-CA-92104/home-values" but what I want is, that I have my several inputs which will at the end result in "San-Diego-CA-92104/home-values" (easy with excel) and then execute the macro by grabbing the last result. But it doesn't because I always have to click in it so far. Do you understand now what I mean? Thank you so far.

Hi, daggat,

Worksheet_Change needs a direct entry or edit to a cell. If you placed a Formula in that cell you should either monitor the cells which deliver the values for that cell or use Worksheet_Calculate as that event would be triggered on any recalculation (it may be restricted to work on a sheet or in part of a sheet) and allow a code to run when any calculation is made, if you use it for a workbook or worksheet any volatile formulas like Date/Now/Rand would also start the macro as they force a calculation.

Ciao,
Holger

Okay I solved the problem

it may not be a nice solution but it works.

Just to show what I meant

Please Login or Register  to view this content.

Thanks for the responses though!!!!!! I really appreciated!!!

David

I'm really curious about this, because I'd like to be able to do something similar. How is it supposed to work, because it won't do anything for me. I changed visible to true and tried changing the values of all the cells to be different cities and nothing happened.