Autofill Help Needed

[oldmelon]

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?

 

[BrianB]

Don't see the problem because your suggested solutions are correct.
Bla* means "Bla" with anything following
Blu* means "Blu" with anything following.

 

[oldmelon]

Yeah, that's what I thought too. Tried it, but doesn't work.