Hi. I am trying to learn VBA for Excel from a textbook at home. I have MOUS Excel expert. I am wasting huge amounts of time trying to find the answers to niggling liitle problems that seem to continually stuimp me.
I am currently doing an exercise where a user inputs a password. I store it as a string variable. The characters are all SUPPOSED to be upper case. You then have to check. There must be something which returns the CASE property of a character but I'll be darned if I can find it. Any ideas gratefully and lovingly accepted.
On a more general note, for those who have really conquered VBA - how did you learn it?
A class? Online course? Books? Just picked it up? I find that without an instructor to help out, the textbbok method is proving to be an exercise in continual frustration.
I am currently doing an exercise where a user inputs a password. I store it as a string variable. The characters are all SUPPOSED to be upper case. You then have to check. There must be something which returns the CASE property of a character but I'll be darned if I can find it. Any ideas gratefully and lovingly accepted.
On a more general note, for those who have really conquered VBA - how did you learn it?
A class? Online course? Books? Just picked it up? I find that without an instructor to help out, the textbbok method is proving to be an exercise in continual frustration.