cell validation with list drop down by using a makro - Excel bug?
 

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?

cell validation with list drop down by using a makro - Excel bug?
 

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?

cell validation with list drop down by using a makro - Excel b
 

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?