ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel VB documentation and coding asistance (https://www.excelbanter.com/excel-programming/423352-re-excel-vbulletin-documentation-coding-asistance.html)

Harald Staff[_2_]

Excel VB documentation and coding asistance
 
Also; go Tools Options in the VB editor and check "Require variable
declaration". This puts Option Explicit on top of your new modules.
Backside is (surprise) that you must declare all variables and be careful
with ypur spelling, bonus is better intellisense and more helpful error
messages.

HTH. Best wishes Harald

"John" wrote in message
...
Where do I find documentation that will tell me what all the Excel VB
coding
functions are?

Is there some way I can get or use the Excel 2007 VB editor to be a little
more helpful producing correct code?

This might help me to figure out more things on my own and not bother
forum
experts so much. I'm pretty green at this VB thing, but am a good
learner.

Thx for your help, John




All times are GMT +1. The time now is 10:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com