Hello, I am still a newbie...but learning on job
I am attempting to create an autofill functionality into some cells. Basically, so you only have to enter the first letter of the word. Which I can do, but I am not sure how to do this if I need to enter more than 1 letter.
For example,
If x Like "R* Then
R.Value = "Red"
EndIf
But I need something like,
If x Like "Bla*" Then
R.Value = "Black"
ElseIf x Like "Blu*" Then
R.Value = "Blue"
EndIf
Is there a way to accomplish this?
I am attempting to create an autofill functionality into some cells. Basically, so you only have to enter the first letter of the word. Which I can do, but I am not sure how to do this if I need to enter more than 1 letter.
For example,
If x Like "R* Then
R.Value = "Red"
EndIf
But I need something like,
If x Like "Bla*" Then
R.Value = "Black"
ElseIf x Like "Blu*" Then
R.Value = "Blue"
EndIf
Is there a way to accomplish this?