UserForm DropDown Menus

Ok so I know I have to use the ComboBox but I don't know what code to put inside so it would display the range A on sheet2 and skip the empty onse. Thats what I need help with please.

you could also try a scripting dictionary. This will read a column, delete duplicates as it says it's already in the dictionary.

starts naming where your sheets located, the sheet it's reading from, cell range 2,1 just change to the corresponding column your on

Please Login or Register  to view this content.

Oh...so it's that complex eh? Ok I'll try them and tell how it goes.

Thank you for the help.

if your stuck upload a sample worksheet and I'll put in place one for you.

No it's ok, I want to make it work on my own if I'll have any problems then I'll ask for help, I just that I don't understand these 2 codes, usely I do but hey I have to learn somehow. Give me 1hr I'm working on something else also in excel but will get to this soon and I'll tell if it works like I mean or not
But thank you very much for the help and for the offer

sum up mine is it reads your A:A column and inputs whatever is in their to a "dictionary" so it wont put data twice as once it's added to the dictionary it will only display it once.

(.Cells(2, 1), .Cells(.Rows.Count, 1).End(xlUp))
position two cells down/1 accross in column 1 in A so it Starts from "A2"

kieranbop:

What do I have to do with this? Enter where my workbook is located at or leave it?:

Please Login or Register  to view this content.

I don't get this part... why would I want to open the same workbook again?

pike your code works great my only problem is I don't know where I could put in that it starts with range A1 yes but on a diferent sheet not the sheet I'm on?

oh sorry I thought you was reading from a different workbook, if your reading from current workbook then just activeworkbook.active instead then still name the sheet to look at.

Please Login or Register  to view this content.

I can't get it to work... am I doing something wrong again, did I not enter the data correctly?

Please Login or Register  to view this content.

Doesn't work.

cboAnalysis is the name of the combobox, is your combo box called cboAnalysis? and I thought it should be reading from "Sheet2" not "UserFormInfo"

Originally Posted by kieranbop

cboAnalysis is the name of the combobox, is your combo box called cboAnalysis? and I thought it should be reading from "Sheet2" not "UserFormInfo"

I changed the combobox name to cboDobavitelj like it should be and the name of the sheet that it should be taking data of it is named UserFormInfo I just renamed it

Please Login or Register  to view this content.

Here is how I'm using it.
And the error is Runtime error 1004
and it says something about the order of the filtering is not vaild and that the first row should not be empty or should not have the same name? I don't know what the error's about.

so is mine working now or not? if not upload your workbook

snb. Now it works! Super Thank you very much, all of you.
kieranbop I couldn't get yours to work. I don't know why. If you want you can still try to take a look why it didn't work, I'll upload my workbook.
pike - I didn't know how or where to add the sheet it your code but it would have worked good.

Thank you very much for your help!

Ok so snb looks like the code expired or something I don't know

It doesn't even let me open the UserForm...

Help again please.

Also can I not have to Inicilize codec in there? for 2 different dropdowns in the same UserForm?

Many thanks.

I've Uploaded the file so if one will take a look you will see the error.

So I changed the merged cells in to seperate cells and recopyed the code in to VBA and it's still not working It shows me like I have a problem with the name of the table. Cuse when I hit debug it goes it colors

Please Login or Register  to view this content.

But when I don't have your code in the VBA it works fine. But then I'm withouth the code :/

And I was just joking about the expire part

@snb

I don't know what wrong anymore.
You gave me back my workbook where the code works, and I copyed the same code as you put it in the Narocila snb. And when I do the UserForm doesn't show up anymore but I get an error. When I take the code out again then the UserForm shows back up. It worked once and I didn't change a thing and it stoped working. whats up with that?

sorry for not replyn so long.

Everything is named right. And when I call the UserForm it comes up if it doesn't have the Initialize code.
But I was checking the properties of ComboBox and I saw I can enter there witch range I want it to refer to. And it work, Now my only problem is that it counts the empty ones couse I set the Range A3:A250 And I didn't have to enter the code to make it happen. So is it possible to somehow enter that it lefts out the empty ones?

This continues here:

http://www.excelforum.com/excel-prog...-userform.html

So this one is solved.