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,


Use below code in UserForm_Click() or UserForm_Initialize()
TextBox1.Text = Range("H65536").End(xlUp).Value

Regards,
Kunal

 

[stnkynts]

Not sure if this is what you are looking for but if you are populating column H with customers names in order (ie the last entered customer is in the last row) then you should be able to set up a text box to display the last row's value upon initialization of the userform.

Example:

Private Sub TextBox1_Enter()
TextBox1.Value = Range("H" & Rows.Count).End(xlUp).Value
End Sub

 

[singupalli]

It does work

Both

But the issue is it showing only the last entry, not my previous entered customer names

 

[kunal_shrivastava]

You said that the previous enteries are stored in the Excel sheet in column h. Thats why we are returning the latest value if column H.

 

[singupalli]

The way i put it was wrong.


I want the Text Box of Customers to show me the list of Customers in ColumnH, But if None then i enter the new customers name, this new name.

sorry

 

[kunal_shrivastava]

Do you mean this way:
Suppose we have below names in Column H

John
Ran
Michell
Ramaon
Shane

Then the text box to display all the above names as below:
John Ran Michell Ramaon Shane
??

 

[singupalli]

Somewhat in this format

http://www.mrexcel.com/forum/showthread.php?t=524290&highlight=auto+fill+text+box

But not sure how to change this code to my requirement

 

[Norie]

Use a combobox to display the list of customers.

You can then use that to get the data for the chosen customer from the worksheet.

 

[singupalli]

yes Kunal

Thats almost what i want,

But for example i already Have John and Joseph

then
When i type "Jo" al names with :Jo pop up
Joh - then i get John
Jos - then i get Joseph