Editing a code that sorts data for Dropdown in a UserForm

[stojko89]

Hi

Not long ago pike gave me this code I was looking for:

Please Login or Register  to view this content.

But my problem is that it work for the active sheet that the userform is on.
What I'm tryn to do is so it takes the data from a sheet called UserFormInfo
And I tryed this but it gives me an error:

Please Login or Register  to view this content.

Is it not possible to use Sheets("UserFormInfo").Range in this code?

[Steffen Thomsen]

In this line of code you've missed something

Please Login or Register  to view this content.

You need to insert Sheets("UserFormInfo")

Steffen Thomsen

[kieranbop]

For Each xCell In Sheets("UserFormInfo).Range("A1", Cells(Rows.Count, 1).End(xlUp))

if you change that to:

Please Login or Register  to view this content.

Missing " " either side of UserFormInfo , you might have some more luck

[stojko89]

Ok so that was dumb
But now I inserted the " " on both sides.
Now when I try and run the UserForm that this is attached to it says Error and when I hit Debug it colors this line:

Please Login or Register  to view this content.

Any other idias?

[kieranbop]

Post up a sample workbook and I can take a closer look.

[stojko89]

This is the wb I'm working in. The Button Novo Naročilo in the rop right corner of the selected sheet calles the UserForm that has this dropdown inside under Dobavitelj: but you will see the error when you click the button to call the UserForm.

Thanks for taking a look!

[kieranbop]

the sheet your looking for doesn't exsist? so when you load the userform, it's looking for that sheet. I can't see no UserFormInfo? Is it supposed to be looking to a different workbook with the worksheet "UserFormInfo" or?

[stojko89]

The Sheet is there it's just hidden. Use right click on sheet narocila Unhide and select Sheet UserFormInfo there are alot of sheets there.

[kieranbop]

replace this in:

Please Login or Register  to view this content.

seems to load no errors for me now. if any problems come up just check what your calling your dim's etc as as in previous sheet userform nothing is in "A1" and it's always better to loop through cells

[stojko89]

Oh ****...damn I make problems where they don't need to be. I'm sorry kieranbop

The count is sopose to start from cell A3 on sheet UserFormInfo

so I change the cell in this code:

Please Login or Register  to view this content.

But the code you gave me with the numbers 65535 gives me an error and says object required and when I hit debug it color this line:

Please Login or Register  to view this content.

[kieranbop]

what version are you using? and you will just have to put breakpoints in and you will see what's going wrong on your end, You need to check it's actually passing in values

[stojko89]

Excell 2007. Sure I'll try

[stojko89]

When I put in the brake point and go line to line and when I get to this line:

Please Login or Register  to view this content.

It just says theres an error and I can't go on anymore.

[Steffen Thomsen]

Try splitting this line in to two

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Steffen Thomsen

[nilem]

Try it:

Please Login or Register  to view this content.

[stojko89]

nilem

The code you gave me. Left the Dropdown menu empty.

Steffen Thomasen

The code works great! As expected. I just changed The rage from A1:A to A3:A so it doesn't include those 2 cells.

So thanks a lot man! And thank you all for your time and effort!

[Steffen Thomsen]

Your welcome!