I remember the days of the nice Visual Basic 6. I even remember some nice VBA in Access that I have done. Actually, I have some old code that I still use in an old MS Access Database.
But vba it has always been “strange” to say the least.
It appears that when you Dimension a variable (dim) that has properties (an object) , and if you declare more than one in the same line, some of the intellisense won’t work. I’m not sure if this happens all the time.
Dim ws,wd as Excel.Worksheets
I’m glad that I get to do C++, Java, Python now days… after this vba problem, I’m even glad to use other languages that I have to interact with in a daily basis.