Textbox

[dwarek]

Hello i would like to know whether there is possibility for a textbox in a userform to rememeber the value which entered previously. For Example if i type INDIGO in textbox 1 and click on command button the value will be passed to the worksheet so next time if i type IN then the word INDIGO should be suggested.Is there any vba code for that.
thanks n advance

 

[Alan_P]

Hi dwarek,

I'm not sure about a TextBox but you could something like the below with a ComboBox and a helper column to store the previous entries...

Private Sub UserForm_Initialize()

LastRow = Range("A" & Rows.Count).End(xlUp).Row

ComboBox1.RowSource = "A1:A" & LastRow

End Sub

Private Sub CommandButton1_Click()

LastRow = Range("A" & Rows.Count).End(xlUp).Row

Range("A" & LastRow + 1).Value = ComboBox1.Value

Range("A:A").RemoveDuplicates Columns:=1, Header:=xlNo

End Sub

Hope this helps,
Cheers,
Alan.