Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validation
Thanks to those who have helped me to create a 'drop down' list using data
Validation, however I have just one more question. When I click into the cell to show the drop down menu the 'down arrow' symbol appears, but then will disappear when I click out of this cell. Is there a way to make this 'symbol' stay on the worksheet all times ?? regards |
#2
|
|||
|
|||
Not with validation, you would need to create a combo box for that
Regards, Peo Sjoblom "Anthony" wrote: Thanks to those who have helped me to create a 'drop down' list using data Validation, however I have just one more question. When I click into the cell to show the drop down menu the 'down arrow' symbol appears, but then will disappear when I click out of this cell. Is there a way to make this 'symbol' stay on the worksheet all times ?? regards |
#3
|
|||
|
|||
Hi Anthony
no .. alternatives are - colour the cell to indicate that there's something different about the cell or someone suggested (in a recent post - sorry, can't remember who) drawing a drop down arrow on the cell ... but i've not tried that. Cheers JulieD "Anthony" wrote in message ... Thanks to those who have helped me to create a 'drop down' list using data Validation, however I have just one more question. When I click into the cell to show the drop down menu the 'down arrow' symbol appears, but then will disappear when I click out of this cell. Is there a way to make this 'symbol' stay on the worksheet all times ?? regards |
#4
|
|||
|
|||
"JulieD" wrote in message news:... Hi Anthony no .. two alternatives are - colour the cell to indicate that there's something different about the cell or someone suggested (in a recent post - sorry, can't remember who) drawing a drop down arrow on the cell ... but i've not tried that. Cheers JulieD "Anthony" wrote in message ... Thanks to those who have helped me to create a 'drop down' list using data Validation, however I have just one more question. When I click into the cell to show the drop down menu the 'down arrow' symbol appears, but then will disappear when I click out of this cell. Is there a way to make this 'symbol' stay on the worksheet all times ?? regards |
#5
|
|||
|
|||
If you set it up as a combo box or list box (forms toolbar), the arrow(s)
will stay on the cell. Carole O "JulieD" wrote: "JulieD" wrote in message news:... Hi Anthony no .. two alternatives are - colour the cell to indicate that there's something different about the cell or someone suggested (in a recent post - sorry, can't remember who) drawing a drop down arrow on the cell ... but i've not tried that. Cheers JulieD "Anthony" wrote in message ... Thanks to those who have helped me to create a 'drop down' list using data Validation, however I have just one more question. When I click into the cell to show the drop down menu the 'down arrow' symbol appears, but then will disappear when I click out of this cell. Is there a way to make this 'symbol' stay on the worksheet all times ?? regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Validation List and VLookup are ackting strange | Excel Worksheet Functions | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Validation list behaving strangely in 2003 | Excel Worksheet Functions | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |