VBA UserForm || Textbox Autofill Using Worksheets

[sachinns]

Hi Friends,

I Have a userform consisting of some textbox. I wanted to add one feature to the textbox1 like Auto filling when we write.

Example : I have a sheet where 2 columns are there. One is A and another is B. I have some datas in these columns as well.

So when user starts write in textbox1 , then it should autofill the textbox using the datas available in the Column A.

Can somebody help me on this.


Thanks

 

[mikerickson]

Try this

Private Sub ComboBox3_Change()
'...

Dim i As Long, Lastrow As Long
Dim otherValue as Variant

otherValue = Application.VLOOKUP(Combobox3.Text, WordsRange.Resize(,2),2,False)

If IsError(otherValue) then otherValue = vbNullString
Me.Textbox2.Text = otherValue

End Sub

 

[sachinns]

@mikerickson

Thanks A lot. You saved my ***.

 

[sachinns]

@mikerickson

I solved. Thanks