Interesting/Useful _VBA/Excel links over the internet

[Deepak]

Create an online survey with Excel like as Google forms...

https://wmfexcel.com/2018/01/14/excel-online-survey-never-heard-about-that/

The basic difference is that- Google forms allowed addin & File upload also introduced.

 

[Chihiro]

Method to use "ScriptControl" in Excel x64 install. See 1 post below accepted answer.

https://stackoverflow.com/questions/9725882/getting-scriptcontrol-to-work-with-excel-2010-x64

 

[Chihiro]

Site with lots of info on Excel and Web Services (Rest, JSON etc) and Google script related topic.

http://ramblings.mcpher.com/Home/excelquirks

 

[Deepak]

Mr faster : Advance Filter

 

[Deepak]

New talk of the spreadsheet lovers and vlookup bluffers...

Here's XLOOKUP

Announcing XLOOKUP

October 29th Update While preparing XLOOKUP for general release, we have been listening to the incredible feedback from our Insiders. A leading suggestion was that XLOOKUP could be made even better by adding an [if_not_found] argument. We’ve heard you loud and clear and have gone ahead and...

techcommunity.microsoft.com

 

[NARAYANK991]

Hi ,

For those who have access to these new functions , a great reference , and for those who do not have the new functions , a reason to upgrade.

https://www.mrexcel.com/download-center/books/2018/ExcelDynamicArraysStraightToThePointV2e.pdf

Narayan