Excel Userforms are a Pain in Ass
Excel is a spreadsheet program. It can do some awesome stuff with spreadsheets. But there are some other features that can be used to turn it into something beyond just a spreadsheet program. One of those features is the ability to add userforms, which can prompt a user to enter information.
Unfortunately, unlike web forms or even Infopath, Excel userforms don’t work very well. The UI is extremely sensitive to every small movement, it’s nearly impossible to select multiple controls without selecting all of them, and the method for using the data you collect is non-intuitive and clunky (most of VBA could be described as clunky).
If anyone has experience working with userforms in Excel and can offer some suggestions to bring me off my ledge, I’d appreciate it.
