Can anyone recommend a resource that will help me to make sense of userforms? I'm really struggling, (not for the first time).
At the beginning of my project I ask the user for input. I have used InputBox which has been fine for my purposes up to now.
This is great as it stores the response as a variable which I can get my head around relatively easily and use wherever I need to. Obviously the weakness comes with end users entering bad data causing the code to crash or produce incorrect results.
What I'm hoping to do is 'force' the user to make an entry based on a choice of two possible entries. These choices will be "Current" and "Prior".
I can set up the userform with Option buttons and, after some faffing around, I can make it appear on screen with an appropriate line of code.
The user form basically only has a choice between "Current" and "Prior", along with "OK", "Clear" and "Cancel" buttons. I can't for the life of me work out how to get the choice of "Current" or "Prior" to pass to a variable in my main Sub Routine. Is there anywhere that can explain this to me clearly, (and, it would appear, in language a simpleton would understand)? I've been round the track with userforms quite a few times in the past.
As an aside I'm also struggling to save my workbooks when I'm working with userforms. Is there something I'm doing wrong there?