Tag Archives: VBA

Excel: Dynamic formulae

By | August 15, 2009

I was asked yesterday if there was a way to populate a worksheet with formulae as the user (third party) was adding data. This would stop the need for the worksheet to be pre-populated with formulae or require the user to add the formulae – especially if there were a data input clerk only. So… Read More »

Sean’s Problem Number 1

By | August 14, 2009

Well Sean, here a solution to the first of your problems :-). I’ll explain the code (although you can just use the spreadsheet attached at the end of this article). For those not familiar with this, Sean has a simple problem, in that while entering part numbers for OLE equipment in on worksheet he wish… Read More »

Excel VBA Functions

By | August 12, 2009

It occurred to me after I had written the previous article that I didn’t explain to those who don’t know, how to write the VBA function – so there’s the solution. First you need to open the Visual Basic Editor by either selecting it from the menu (Tools | Macros | Visual Basic Editor) or… Read More »