Goal Seek Macro

Hi I'm having trouble making a macro that performs an automatic goal seek on a cell with the click of a button.

My set cell = I11
Value = 5,600,000
By changing cell F8

This should be pretty simple for all you gurus on here. Thanks!

I think there is a built in addin to do just this, Solver. Its comes with Excel all you need to do is activate it.

This was exactly what I needed. Thanks so much!