VBA and Right( ) functino (Excel 2000 and 2003)

Topic

New Reply

Hi , I’m stuck …

Say, I have text in Cell B1. And, I need to check if the last character is an “F”.
I can do this easily in a cell on a sheet/tab by using:
=IF(RIGHT(B1,1)=”F”,”Do True Stuff”,”Do False Stuff”)

However, I need to do this in VBA code …and I don’t know how.

So, any help would be really appreciated.

Nite,
–cat

Reply | Quote

Replies

It’s pretty much the same:

Sub TestForF()
    
    If Right(Range("B1"), 1) = "F" Then
        MsgBox "true"
        Else
        MsgBox "False"
    End If
End Sub

Reply | Quote