excel - Is there a way to seek documentation for VBA, that is not for VB.NET? -


i'm using vba in excel, , using almighty google find functions, classes, methods browsing html, string manipulation etc. question possibly general future usage.

usually find microsoft documentation pages. figure out way use them, not. example found function "filter" (https://msdn.microsoft.com/en-us/library/fat7fw0s(v=vs.90).aspx) string manipulation seems vb, not vb.net have trouble running example code. "variable not defined" error "comparemethod" constant.

i specific situation suspect may need add references code in order compilator recognize symbols.

as different example: used function split (https://msdn.microsoft.com/en-us/library/microsoft.visualbasic.strings.split.aspx), seems vb.net, seems work intended in vba code.

my question: can please not explain me happening here, more importantly stir in right direction showing, can find vb functions , classes documented , references explained in way, allows me add them in excel vba code?

edit: emphasize see requirements part of description, doesn't me in excel, since can access libraries through tools > references, , names there quite different namespace, module , assembly names on microsofts' site.

here go - site use lot. has functions on tons of other vba useful things. http://www.techonthenet.com/excel/formulas/index_vba.php

this 1 rest of vba, macro's, , other tools excel vba http://www.techonthenet.com/excel/macros/index.php


Comments

Popular posts from this blog

dns - How To Use Custom Nameserver On Free Cloudflare? -

python - Pygame screen.blit not working -

c# - Web API response xml language -