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?

try changing the Semi colons to commas:

Formula1:="1,2,3"

--
Regards,
Tom Ogilvy


"Matthias" <[email protected]> wrote in message
news:[email protected]...
> 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?

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>
>