Automatically fill some data in a textbox when I choose an option from the combo box

**aayush_1231** · 06-17-2019, 03:15 AM

Hey!
I am sorry if this has been posted here before, but I'm working on this userform(Attached).
I need to fill in build a combo box that will have various cities. When I choose a particular city I want the "Customer Number" to automatically fill with the first 3 alphabets of the city or some other alphabets that are used to abbreviate the city's name. for eg, I choose Hyderabad from the combo box and the customer number should look like "HYD001" or "HYD1"
Can someone just mention a piece of code that can help me get started. I am stuck here and can't find a way through.

Thankyou for any help you put forward

**dmcgov** · 06-17-2019, 07:46 AM

Please Login or Register  to view this content.

is that what you are looking for?

**aayush_1231** · 06-17-2019, 03:43 PM

Hi!
Thankyou for your reply. I actually want to get data from the combo box into my textbox.
Like I'll choose a city and then my chosen city will be displayed in another textbox that has customer number in it

**aayush_1231** · 06-17-2019, 03:43 PM

Originally Posted by dmcgov

Please Login or Register  to view this content.

is that what you are looking for?

Hi!
Thankyou for your reply. I actually want to get data from the combo box into my textbox.
Like I'll choose a city and then my chosen city will be displayed in another textbox that has customer number in it

**dmcgov** · 06-18-2019, 06:16 AM

then try this:

Please Login or Register  to view this content.

**aayush_1231** · 06-20-2019, 03:23 AM

Originally Posted by dmcgov

then try this:

Please Login or Register  to view this content.

Does this code go under Private Sub UserForm_Initialize()?

**aayush_1231** · 06-20-2019, 03:42 AM

Originally Posted by dmcgov

then try this:

Please Login or Register  to view this content.

I got to work the combobox. When I choose a city, the first 3 alphabets of the city are showing but I cannot get the number in there somehow.

My field is :-
Customer Number :- Hyd01
I can get to Hyd but I am stuck on how to get 01 in there.
It gets generated automatically when i login to the userform but when i choose the city only the city name appears. the number disappears

**dmcgov** · 06-20-2019, 07:58 AM

can you post the code that you have? i need to see where you are getting the count variable.

**aayush_1231** · 06-20-2019, 08:09 AM

Originally Posted by dmcgov

can you post the code that you have? i need to see where you are getting the count variable.

I have this code that generates the number when I open the userform
Private Sub UserForm_Activate()

Dim CUST_NUM As Long

CUST_NUM = Cells(Rows.Count, "B").End(xlUp).Row

Me.CUST_NUM.Value = Cells(CUST_NUM, "B").Value + 1

End Sub

**aayush_1231** · 06-20-2019, 08:10 AM

Originally Posted by dmcgov

can you post the code that you have? i need to see where you are getting the count variable.

and

CUST_NUM.Text = Cells(LastRow + 1, "B").Value + 1

generates a new number when i click on the add button in my userform.

I have attached the userform in the initial post.
the login credentials are :-
admin
saibabu

incase you want to download and look at the code yourself

**dmcgov** · 06-20-2019, 08:20 AM

try this:

Please Login or Register  to view this content.

**aayush_1231** · 06-20-2019, 09:16 AM

Originally Posted by dmcgov

try this:

Please Login or Register  to view this content.

where does it go? userform_initialize?

**aayush_1231** · 06-20-2019, 09:24 AM

Originally Posted by dmcgov

try this:

Please Login or Register  to view this content.

I put the code under Private Sub dist_change()
dist is the (Name) of my combobox.

I'm getting a mismatch error. The code you provided is clashing with CUST_NUM.Text = Cells(LastRow + 1, "B").Value + 1

**dmcgov** · 06-20-2019, 09:35 AM

i downloaded your workbook, still can't get it to work right. will keep trying.

**aayush_1231** · 06-20-2019, 11:22 AM

Originally Posted by dmcgov

i downloaded your workbook, still can't get it to work right. will keep trying.

Sure! Thankyou so much. :D
I'm trying too. Will update if I get to work it right. Be free to make any changes in the code you think isn't necessary or is causing trouble. let me know if you work it out
Cheers!

**aayush_1231** · 06-25-2019, 02:53 AM

Originally Posted by dmcgov

i downloaded your workbook, still can't get it to work right. will keep trying.

Hey!
Any progress??

**dmcgov** · 06-25-2019, 06:24 AM

no luck so far, might have to ask one of the guru's for help

**D_Rennie** · 06-25-2019, 06:33 AM

Hi,

you need to add to your userform coding

Please Login or Register  to view this content.

not sure where you are getting the origional customer number from, though this MUST be a asending number or it can throw out records. Edit just seen where you are getting the unique number "this should be fine"

hopefully dmcgov will keep helping as i am super bussy ATM, Though will cheek in when i can

**aayush_1231** · 06-27-2019, 02:57 AM

Originally Posted by dmcgov

no luck so far, might have to ask one of the guru's for help

Ahh!
I have searched alot with no help. My project is due in like 5 days :3
Anyway, I'll keep searching and let me know if you make a breakthrough
Thankyou!

**aayush_1231** · 06-27-2019, 02:58 AM

Originally Posted by D_Rennie

Hi,

you need to add to your userform coding

Please Login or Register  to view this content.

not sure where you are getting the origional customer number from, though this MUST be a asending number or it can throw out records. Edit just seen where you are getting the unique number "this should be fine"

hopefully dmcgov will keep helping as i am super bussy ATM, Though will cheek in when i can

Sure!
No problem. Just update me when you find a breakthrough
Thankyou!

**aayush_1231** · 06-27-2019, 03:10 AM

Originally Posted by dmcgov

no luck so far, might have to ask one of the guru's for help

Hi!
I'm thinking of dropping the previous idea.
Instead I've decided to use a list box to search my already stored values. Can you help me out with that?
Like if I search Hydrebad, all the fields stored in Hydrebad are displayed or I can search by name of the customer or their customer number.
Can you help me with this problem?
I'm also uploading an updated version of the sheet where I've included a listbox and stuff.

Thankyou!

Automatically fill some data in a textbox when I choose an option from the combo box

LinkBack

Thread Tools

Rate This Thread

Display

Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Re: Automatically fill some data in a textbox when I choose an option from the combo box

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Drop down option automatically choose based on answer

[SOLVED] Fill a textbox with varaible text depending on Radio Button selection combo

Fill date/time in box when select option from combo box

VBA Countif to fill textbox based on two combo boxes

fill dot or slash automatically to date in Textbox

VBA index match to to fill textbox form combo?

The option to choose data in Excel?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions