excel solver like Public Function

The loop in your function doesn't do anything -- nothing changes, so it will loop forever.

The reason I cant use solver is because the solver add-in doesn't automatically recalculate as the values in the cells are changing.

I don't understand that.