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

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pick from drop-down list gives empty or erroneous result 6
Data Validation Drop Down Using VBA? 1
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Check Validation List for Matching Entries at Start-up 14
changing validation drop down based on another cell value 5
Drop Down List Format 2
Data validation drop down list selection change 4
Runtime-error 1004 (excel 2007) when selecting validation list optiontriggering worksheet_change pro 1

Top