98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA Formula
VBA Formula
Resolved · Medium Priority · Version 2016
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
Thu 2 Apr 2020: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:How to select certain data in an Excel 2010 workbookIf you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique. |
