mid, right in a private sub/ Problems

[jgoulart]

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

 

[Dave Hawley]

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.