mid, right in a private sub/ Problems

jgoulart · Mar 3rd, 2002, 07:22 PM

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 · Mar 3rd, 2002, 07:49 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 3rd, 2002, 07:22 PM	#1
jgoulart Board Regular Join Date: Feb 2002 Location: John G Posts: 62	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

Mar 3rd, 2002, 07:49 PM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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.