I'm trying to run string functions mid and Right in private userform command button sub and they don't seem to be working correctly. How should I get around this?
John
Hi
You haven't said just what's not working, but I am guessing you are parsing strings stored in variables? As you need them in Private Modules you must declare them at the top of a normal module (public) as Public, eg
Public strMyWord as String
This will dimension the variable at Project level.
Like this thread? Share it with others