[RESOLVED] Question Please!

[ASoufan]

I have Text Box Control called txtCount

txtCount.Text = "Users Count " & X & " Now"

it could be something like this
"Users Count 56 Now" or "Users Count 3 Now" ...etc

How can I make a short code that takes the Value X between "Users Count " & " Now".

Thanks

[INV-Predator]

Hi ASoufan, once again i'd love to help but i don't really know what you want to do? Do you want a piece of code to give X a value?

[d3gerald]

could you elaborate more on what you want to do.

[ganeshmoorthy]

do you want to find out the value of x from the text box, after assigning the text to it...why dont you call the x if you have a variable...or use mid function

MsgBox Val(Mid(txtCount.Text,13))

[INV-Predator]

ahhh, now i understand, you want to isolate the X value from the string located in txtCount. use one of ganeshmoorthy's methods.

[ASoufan]

Thanks guys, I got the function that get a part of text from full text

Function GetTXT(FullTXT As String, StartTXT As String, EndTXT As String) As String
    GetTXT = Mid(FullTXT, InStr(1, FullTXT, StartTXT) + Len(StartTXT), InStr(1, FullTXT, EndTXT) - InStr(1, FullTXT, StartTXT) - Len(StartTXT))
End Function

It will be like this

MsgBox GetTXT("Users Count 56 Now","Users Count "," Now"

This will apear 56 or any string a message Box.

*RESOLVED*

Thanks!

[ganeshmoorthy]

you are most welcome

[Hack]

Thanks guys, I got the function that get a part of text from full text

*RESOLVED*

Thanks!

If you consider this resolved, would you please pull down the Thread Tools menu and click the Mark Thread Resolved menu item? That will let everyone know that you have your answer.

Thank you.