Convert MS Excel Formula to VBA code

How to convert an MS Excel formula to VBA code.
For details visit:
www.exceltrain...
Feel free to subscribe to my channel.
For more interesting videos on MS Excel:
www.exceltrain...

[@bennysebastian5316]

Wow!!Thankssssss dear Sir. So nice!!!!

[@alializadeh8195]

Thanks

[@glitterworldcreation]

excellent sir!!!

[@MKP2788]

I have multiple sheet like sheet name 1 2 3 4 5 6 in this sheet I am using sumifs formula from another workbook I need to copy the data to another workbook with paste special. In another workbook I have sheets like 1 2 3 4 5 6 need to pastespecial in same sheet

[@TheMilindchankapure]

how to do sumifs for smrange in different workbook and criteria range in different workbook and criteria value in same sheet where i am doing sumifs

[@rameshraaz]

Good morning sir, I have one basic question. I want to highlight first and last Saturday in Excel through conditional formatting

[@k102stone]

HI, I'm having trouble finding a way to enter a formula into a cell when entering it from a Userform. I have a list of contacts and in the last column i have this formula that compares the id Numbers on another sheet to find out who is not on the list or the formula leave an N/A in the cell. If the ID NUMBER is not on both sheets. here is the Formula: =VLOOKUP(A2,idNum,1,False) when i enter a new contact into the sheet using Userform the contacts are added to the last row. I need away to insert a formula in Column U and update the row number in the formula to line up with the row number the contact info is going into. so the next formula would look like : =VLOOKUP(A3,idNum,1,False) Any Ideas? Thanks

[@Exceltrainingvideos]

This link might help: www.exceltrainingvideos.com/data-entry-with-userform-vlookup-countif-dynamic-named-ranges/

[@k102stone]

Thanks for the help...

[@bunasantosh1132]

Hi sir , vlookup problem how to write vba for salary ,or tax please i need a video

[@Em_chivan]

Hi teacher please show formula in VBA application formula ex: application.vlookup,application.sum.....

[@Exceltrainingvideos]

This Excel VBA tutorial on Vlookup will guide: www.exceltrainingvideos.com/how-to-use-vlookup-to-get-multiple-values/ My channel has this video on Vlookup in VBA: kzbin.info/www/bejne/pJ6Yn5WYapdnqrc Nobody died till date of doing some search on my channel or website.

[@gerardvaneggermond9967]

can you place it in a cell instead of placing it in an MsgBox?

[@Exceltrainingvideos]

Example: Range("A100")=theCount Cell(100,1)=theCount

[@shivaaashock]

Hi sir, can you please tell the VBA code for converting any time zones to EST time zone.

[@Exceltrainingvideos]

www.cpearson.com/excel/TimeZoneAndDaylightTime.aspx

[@MKP2788]

Hi sir I need ur help

[@womike11]

Unfortunately you have to know VBA code ahead of time in order to convert excel formulas. If you don't know VBA coding then you won't be able to do it. If you do know VBA coding why bother writing an excel formula in the first place.

[@Exceltrainingvideos]

OK. Don't do anything if that makes you happy.

[@womike11]

Thanks for your help anyway

[@sachinpandav8613]

सर 0 installment है तो 0 ही रहे.लेकिन 1 से जादा हो तो हर महिने एक एक से बढती रहे payment sleep मे.please bolo

[@Exceltrainingvideos]

Question not clear. Search www.exceltrainingvideos.com

[@melodylagrama9879]

Nice sir.... sir how can i convert this formula: =D3&"_"&COUNTIF($D$3:$D3,D3)-1

[@Exceltrainingvideos]

This link will help: www.exceltrainingvideos.com/how-to-convert-ms-excel-formula-to-vba-code/ Or search www.exceltrainingvideos.com

[@MKP2788]

Please help me

[@jeffknightcafe]

Hello

[@Exceltrainingvideos]

Hello

[@jeffknightcafe]

Thank u for your response. Can u help with creating a macro that would set the value of a cell based on a list of invoices for example. Hope you can help me on this.

[@Exceltrainingvideos]

Not quite clear. Maybe you can mail me at [e-mail]

[@IntelMan]

He is knowledgeable but too too boring

[@Exceltrainingvideos]

How can I become too too entertaining?