Declaring value type from a transfered variable

[Broobi]

Hi All

Im hoping this will be an easy one...

I have a macro that picks up a variable value from a previous userform, which works great. but for some reason my bit of code that should find said variable value in a column, doesnt seem to recognise it... i have a feeling its because i need to somehow declare it as an integer (the variable value is a number) but i cant work out where or how i tell it this

TicketNumber3 = MainForm.viewticks.Value

varResult = Updateinput


    For Each Cll In Sheets("mi tickets").Range("B2:B" & Sheets("mi tickets").Range("B:B").SpecialCells(xlCellTypeLastCell).Row)
        
        If Cll = TicketNumber3 Then
            If VarType(varResult) = vbString Then
                    Cll.Offset(0, 18) = Cll.Offset(0, 18).Value2 & Chr(10) & Chr(10) & "My Data"
                    
                    varResult = Replace(varResult, Chr(13), "")
                    
            End If
        End If
        
    Next Cll

TicketNumber, is the variable value from the UserForm "MainForm". I know it has remebered it as i tested it in a random cell... but can't work out why the Cll wont use it?

i tried:

If Cll = (CLng(TicketNumber3) Then

but to no avail

Any help would be greatly appreciated!

Many thanks in advance, as always, for any help or suggestions

Many thanks all!

[skywriter]

Try:

VAL(TicketNumber3)