Excel VBA – Avoiding Macros / Visual Basic

Radio buttons are a neat way to enable only one thing to be selected. The downside is that you need to add macros on the back end to make them work. The tutorial below (recorded in Excel 2007, but 2003 options also explainded) offers you a way to use data validation to ensure that only one cell has data entered. It's not quite as good as a radio button, because in order to change your selection you have to delete the original then insert the new, whereas radio buttons do that for you. But if that's not a big overhead, then [...]

Actually, I do like macros, used in the right place at the right time.  Excel macros can be incredibly powerful, but I try to avoid using them if possible. Why? Well, there are several reasons: Undo - There are a few things that break the 'undo' chain, by which I mean that you can't undo anything done before them.  Guess what - running a macro falls into that category.  And it doesn't matter how good you are at Excel, being able to Undo is useful! Audit trails - you can't audit actions taken by a macro, unless you've written the macro [...]