sprintf and printf for VBA – similar to String.Format in .net
Short sweet and to the point – click here.
Making VBA more like .net – Global Constants
Some tips understand scope in VBA – this is NOT VB.net perhaps use global variables and use _CAPS so they are readily identified put them in their own VBA module
Better VBA Error Handling
With VBA, it is generally a solution for one’s self or a small group of individuals. Most of my apps if an exception happens, a yellow line is highlighted in the VBA editor, you investigate the variables LIVE (on thy fly – love that about VBA) and adjust or fix the situation. If the code […]
Excel and web services
So there is an application that requires a best guess – but still human interaction to choose which item when there is more than one result returned. So one can make a web service to pull back a pull down and make a form for the user to make a choice allowing quicker spreadsheets to […]
Really geeky stuff – what is late vs. early binding. Also … Dictionaries in VBA
OK – so I am reading stuff that seems a little too geeky, but after asking “what is this late vs. early binding” stuff – I had to know what it was. Here is a simple explanation – even I can understand. It really does (did) not matter – but the main point is summarized […]