Code doesn't update from a cell?

Hi guys,

i have this code:

Please Login or Register  to view this content.

Now when i change range G7 from E to G the code still pics up an account that has a G? i have to then exit and press "get account" again to get the desired results?

i figure this is like a refresh problem? any ideas?

Cheers for reading my thread!!