VBA Code to Auto Fill Text Box

[singupalli]

Hi

I have a text box in the user form to fill Customers name,

The the previous enteries are stored in the Excel sheet. in column h

when i make a new entry Via the user form, i want the text box Customer name to show the previous entry if already entered/Exists, if not the new name will be typed

Please anyone

 

[kunal_shrivastava]

Hi Singupalli

Reframing my question :
Should we modify the code like this that you double click on the listbox names that pops up and the one selected gets loaded in Cstname text box?

Regards,
Kunal Shrivastava

 

[kunal_shrivastava]

Hi Singupalli,

If you want it like i asked you in previous message, then you need to add below code in listbox change event.

Private Sub ListBox1_Click()
TxtCstname.Text = ListBox1.Value
End Sub

Regards,
Kunal Shrivastava

 

[singupalli]

Hi Kunal

This works Now

Thank you