Notifications
Clear all
VBA & Macros
3
Posts
3
Users
0
Reactions
31
Views
Topic starter
Dears,
Greetings,,
Kindly seeking your support, as I am a beginner in Excel, and I want to ask you about VBA Formula, how do I create a Vlookup formula in VBA? Also, how do I create a dynamic formula in VBA?
Thank you in advance,,,
Best Regards,
Posted : 24/08/2022 5:39 pm
Hi Faisal,
I suggest learning all native Excel tools before using VBA, because many things can be done with a proper excel setup, without vba.
You can record a macro while adding a formula in excel, that will give you the formula syntax.
Should look like:
Cells(1, "D").Formula = "=VLOOKUP(""Search Text"", A1:B10 , 2)"
Posted : 26/08/2022 12:02 am
Look at this link for tutorial
http://www.cpearson.com/excel/CallingWorksheetFunctionsInVBA.aspx
Posted : 26/08/2022 1:05 am