I have a cell G8 that has this formula in it.
=IF($L$8>"",VLOOKUP($Q$6,Customer!$B:$J,5,FALSE),"")
I would like to remove the formula from the cell and have it updated by code.
How would you state this formula in VB. I would like to have it updated anytime there is a change in Cell F3 and/or when the sheet is activated (Sheet5)
Thanks
Dave
=IF($L$8>"",VLOOKUP($Q$6,Customer!$B:$J,5,FALSE),"")
I would like to remove the formula from the cell and have it updated by code.
How would you state this formula in VB. I would like to have it updated anytime there is a change in Cell F3 and/or when the sheet is activated (Sheet5)
Thanks
Dave