mid, right in a private sub/ Problems
mid, right in a  private sub/ Problems
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: mid, right in a private sub/ Problems

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    John G
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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.



User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com