| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Drop Down List if cell meets criteria | Excel Worksheet Functions | |||
| Data Validation - In cell drop Down List | Excel Discussion (Misc queries) | |||
| Validation cell entries (Drop-down list) | Excel Discussion (Misc queries) | |||
| Default Cell Value with Validation Drop-Down List | Excel Discussion (Misc queries) | |||
| Dynamically adding an in-cell drop-down list (i.e. Validation Object) to a cell? | Excel Programming | |||
![Matthias[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
