Help:Problem with ComboBox

**KcA** · 04-03-2008, 05:59 AM

I used the following tutorial in making a combobox: http://www.contextures.com/xlDataVal10.html

I already made the Data Validation, so I just made the combobox step by step, exacly the same (same namesm TempCombo etc.). But it wont work. I have the combobox, when I'm out of design mode you won't be able to see it. Just as it should be. When I double click a cell, the box appears. Till this far everything is going just fine.

But now when I start typing, or press the pull down button. Non of the Data is coming foward. And when I just type something inside of the combobox en press enter, the text just disappears.

In some sort of way it looks like the ComboBox isn't connecting with the cell of data validation.

I hope someone has the solution for me.

Thanks

Edit: I dont know if this matter, but the Data Validation I use, is data coming from another sheet, while the tutorial uses data from the same sheet. Does this make any difference?

Edit again: After some tests, I came to the conclusion that it is infact a sheet problem. I defined a name to 3 cells in the same sheet and changed the data validation source, when I did this, the combobox worked fine. But this isn't what I want, I need it to come from another sheet, hope someone can help me out here.

Please Login or Register  to view this content.

**royUK** · 04-03-2008, 07:30 AM

Are you sure that your code is in the correct modules?

Attach an zipped example workbook if you want it checking

**KcA** · 04-03-2008, 07:40 AM

Yes everything is just the same as the original file. The one you can download from the website. But as I said, it works fine when I link the validation data to cells inside of the same sheet, but when I link the validation data to cells from another sheet, it wont work.

So I tried to change some of the codering from worksheets to workbooks and such. But I don't think I did it with the right ones, I'm new to vba so it's hard for me to tell which ones I should change or whatever I should change to the codering.

**royUK** · 04-03-2008, 08:56 AM

I'm sure that it should not make any difference where the Data validation list is, the code simply uses the list to populate the combobox

**KcA** · 04-03-2008, 10:25 AM

Then why does it works when I test it on some cells in the same sheet and dont work when its in another?

Its obvious that the problem lays there now, isnt it?

**Leith Ross** · 04-03-2008, 12:51 PM

Hello KcA,

Copy this macro. See the line in red in the code. This is were you need to make the change. Specify the worksheet name and range where your list is. The example below sets the list to Sheet2 range "K1:K12". Change this to the sheet name and range you want.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**KcA** · 04-04-2008, 05:26 AM

Ahhhh! It worked!

Thank you very much

!

**SRJ** · 12-13-2008, 12:29 AM

Hi,

This works perfect for me when the workbook is not shared. Is there anyway for me to make it work when it is shared. Plz help.

Thanks is advance

**royUK** · 12-13-2008, 04:11 AM

SRJ, your post does not comply with Rule 2 of our Forum Rules. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.