Urgent: Dropdown Cell Validation Data is shown next to each other

Hey guys,

I have an URGENT problem.

I create a dropdown list with the following code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The problem is: sometimes, the number are not shown as different selectable items, but the string is shown as ONE item. Screenshot is attached. This only occurs sometimes, though?!

Any ideas?

driopdown.jpg

Many thanks,
Klaster

Hey,

so the code doesn't seem to be the problem as it works usually. Just in a single use-case it doesn't: it it's called in the end of a specific routine [Sub add_mass]. As soon as I do sth else containing "Call create_priorityList" it works like a charm.

What could prevent this to work in that specific case?

I tried the following as workaround:

Please Login or Register  to view this content.

Doing this manually works! But putting it in one routine doesn't. Can I d sth so Excel thinks that I run "priority.create_priorityList" manually? ;(

Just for the record: I ended up defining a global variable, that was set TRUE at the end of add_mass and with the next worksheetselectionchange, priority.create_priorityList was called.