Combo Box populating Text boxes

**gadrummer65** · 03-06-2014, 01:52 PM

Hi.
I am new to VBA, and i am trying to have the last Combo box (ComboBox2) to populate all the information from the sheet to the userform text boxes. It all works great, but i can only get it to populate to 2 of the 8 text boxes. If i add more lines so that it will populate to the other text boxes, i am getting an "Not in Range" type of error. I would apprecate any and all help i can get. Thanks

This is the code that i am attempting to use:

Please Login or Register  to view this content.

**gadrummer65** · 03-08-2014, 12:36 PM

I found a code that for the most part works. The only problem i am having is that the combo box is populating the text boxes, but with only the last record in the list. I need it to populate the information from what is choosen in the combo box. Any help will be appreciated.

Please Login or Register  to view this content.

**alansidman** · 03-10-2014, 10:17 AM

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

crossposted: http://www.mrexcel.com/forum/excel-q...combo-box.html

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

**gadrummer65** · 03-11-2014, 10:24 AM

Sample10.xlsm

Here is what i am trying to do. I have a worksheet that has a lot of rows of information. On my Userform, i have 2 combo boxes. They look up information on the sheet (Example....when they pick the city in the first box, the second box populates with hotel choices for that city) The combo boxes work. When i click on the hotel names in the 2nd combo box, i want it to populate the information on the hotel......address, city etc.... RIght now when i click on the hotel, it keep just putting the last hotel on the sheet information in the text boxes instead of what i am choosing. Any help would be appreciated