get number inside the string

[chxxangie]

for example:
Sampling Frequency(ms)....50

how to get the '50' inside the string?
the number will always at the behind of the string, but the problem is the number will not always in 2 digit.....may be 3 or 1 digit.....
so right(str,2) cannot be used in this case.....

[shakti5385]

use Cstr function

[Andrew G]

Will there always be the "...."? or will it sometimes be shorter or longer? Also if it changes in length, will it be the only point in the whole string, or might there be one in the name?

[chxxangie]

Private Sub Command1_Click()
Dim a
Dim b
 
a = "Sampling Frequency(ms)....50"
b = CStr(a)
Label1.Caption = b
End Sub

the answer is not 50....

[chxxangie]

the '...........' is fix......just the number will change

[bushmobile]

Private Sub Command1_Click()
    Dim lPos As Long, lNum As Long, sString As String
    
    sString = "Sampling Frequency(ms)....50"
    lPos = InStrRev(sString, ".")
    If lPos Then lNum = CLng(Mid$(sString, lPos + 1) & ".0")

    MsgBox lNum
End Sub

[chxxangie]

type mismatch......... :'-(

[bushmobile]

type mismatch......... :'-(

i forgot a +1 which I've since added to the code above.

[chxxangie]

yeah, it works......thank you so much......