Trying to fill textbox depending on the combobox value

**Rekragisao** · 03-22-2017, 11:38 AM

Hey Guys and Gals,

I've been searching like mad man for a few hours on an issue that probably has an easy fix, I just can't find it. So i was hoping any of you could help?

I have a sheet named "New Items" inside my workbook, on this sheet data is copied that was filled in trough a userform. Now i have set up another userform for the next user to use to add information onto that.

In UserForm2 i have set up a ComboBox to select the wanted item, displayed in the sheet on column H, and now i want to program a textbox so that it finds and displays the values on Column Q on the same row as the selected item on Column H.

With my limited knowledge of VBA i haven't been able to find how to do this, so if anyone can give me push in the right direction that would be amazing

Kind Regards,

Rekragisao

**AlphaFrog** · 03-22-2017, 12:19 PM

An easy way to do it is to use the ListIndex number of the selected item in the Combobox. The ListIndex numbers in the combobox start at zero and are just a index of each item in the list. The ListIndex Number of the selected item would correspond to the relative row number of the selected item. So if the combobox is populated with values from say H2:H20, then the first selected item in the combobox would have a ListIndex number of 0. If you add 2 to that number, that would be the row number of the first item.

The code below would populate the textbox with the value from column Q of the selected combobox item asuming the combox is populated with values starting from H2.

Please Login or Register  to view this content.

If that doesn't make sense, tell me how you populate your combobox and I'll adjust the code.

**Rekragisao** · 03-23-2017, 06:45 AM

Hey Alpha,

Thanks for the help

after altering the code slightly this works fine for me now.

i Assigned the sheet it should get range Q from and removed the

.Text

property since this caused the text to be in between 2 spaces, which didn't allow me to use the value as guide towards the sheet the data has to be copied in.

Please Login or Register  to view this content.

Thanks again for the help

**AlphaFrog** · 03-23-2017, 11:12 AM

You're welcome.

Trying to fill textbox depending on the combobox value

LinkBack

Thread Tools

Rate This Thread

Display

Trying to fill textbox depending on the combobox value

Re: Trying to fill textbox depending on the combobox value

Re: Trying to fill textbox depending on the combobox value

Re: Trying to fill textbox depending on the combobox value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Transfer data from textbox to sheet depending on combobox

[SOLVED] VBA to add data to textbox from a sheet depending on combobox value

[SOLVED] Textbox fill based on combobox selection

[SOLVED] autocomplete textbox depending on choice of a combobox

[SOLVED] Fill a cell via textbox on userform depending on combobox selection

[SOLVED] Use combobox to fill textbox within userform

Combobox to fill textbox with one of 3 choices

Bookmarks

Bookmarks

Posting Permissions