Wed 25 Mar 2020, 11:50Delegate Yiota said...
Yiota has attended:
Access Introduction course
Access Intermediate course
Excel VBA Introduction course
Excel VBA Intermediate course
VBA Formula
Hello
I want to enter this formula in VBA but I'm not sure how to do it:
IFERROR(IF(BQ4="Y",CE4-200,IF(ISBLANK(BG4),BF4+VLOOKUP(AO4,AWLEAD,2,FALSE),BG4+VLOOKUP(AO4,AWLEAD,2,FALSE))),"")
Thank you
Yiota
Thu 26 Mar 2020, 10:15Trainer Dennis said...
RE: VBA Formula
Hi Yiota
This is a good article on the Microsoft site for using worksheet functions withing VBA.
https://docs.microsoft.com/en-us/office/vba/excel/concepts/events-worksheetfunctions-shapes/using-excel-worksheet-functions-in-visual-basic
I hope this answers your question, if not please get back in touch.
Kind regards
Dennis
