Userform DropDown Filled based on Entry

Hi and welcome.

If you can edit your first post to wrap the VBA in code tags then we can help. Forum rules and all that...

Also, could you advise if the list of values you're looking up from in columns A:C on the List sheet is dynamic or of fixed length? If the latter then what rows does it cover?

BSB

Its in Tabel1 on the Sheet "List" The button for the Userform is on "Map"
Attachment 742775

Its dynamic and pulls the data form another source.

Originally Posted by torachan

always easier for us to give a solution if you post your actual workbook.
see big yellow banner.
all i can say at the moment is your code is not gong to do what you describe, then you already know that !

I would love to post it, I completely agree it is far easier to figure out an issue with the whole picture. If no one can figure it out with out that I will work on making a mock sheet with just the this issue but I can not upload the full file.

That got a 'Compile Error Invalid Next control' whether something on the list or not was entered. I did make a mock version with enough data removed that I can post it if I can figure out how.

Ah! I added the mock version to the original post

So if you enter 12345 in the AC# field, what values should appear in the PN# drop down?

BSB

Each value from column C to G if its possible.

The original formulas that pull information to these columns denote it remaining blank if what it pulls from is 0. I don't mind it being 2 lines of text and 3 lines that are blank after if it makes it work.

OMG BRILLIANT!!!! Thank you so much. I have been racking my brain since last week. I know you guys could see all the old attempts I saved in their trying to figure it out. It works perfect. GENUIS.

Happy I could help

Thanks for the feedback

BSB