Thanks a lot, Tom.
This seems to be the trick.

"Tom Ogilvy" wrote:

try changing the Semi colons to commas:

Formula1:="1,2,3"

--
Regards,
Tom Ogilvy


"Matthias" wrote in message
...
I tried to record a makro while using data-validation and entering seral
list elemtes, e.g.: '1;2;3' in order to create a drop down list. Recording
the makro worked well but when I call the makro there will not be crated
any
list but only one entry consisting of: '1;2;3'.
If the Excel application is saved, closed and opened again the drop down
list will be available.
I found a workaround for this. It's about using a reference cell for the
list entries instead of entering them directly. But this workaround does
not
satisfy my needs

Does anyone have an idea?