| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to keep the drop down arrow on data lists when not selected?
I have data validations set up in a worksheet, and I want to be able to tab
off the lists, and yet still have the arrows viewable. Is this possible to do so? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to keep the drop down arrow on data lists when not selected?
If you use a combo box from the Forms toolbar the drop arrow is always
visible however, a combo box acts a bit differently than a data validation drop down list. If you use the selected item in formulas then it's slightly more complicated but simple once you learn how to do it. -- Biff Microsoft Excel MVP "Diamondgirl" wrote in message ... I have data validations set up in a worksheet, and I want to be able to tab off the lists, and yet still have the arrows viewable. Is this possible to do so? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to keep the drop down arrow on data lists when not selecte
Darn... not quite what I wanted to hear, but I'll try it. Yes, these are
pretty basic lists; therefore the combo box might have to be the trick. Thank you for your quick response! "T. Valko" wrote: If you use a combo box from the Forms toolbar the drop arrow is always visible however, a combo box acts a bit differently than a data validation drop down list. If you use the selected item in formulas then it's slightly more complicated but simple once you learn how to do it. -- Biff Microsoft Excel MVP "Diamondgirl" wrote in message ... I have data validations set up in a worksheet, and I want to be able to tab off the lists, and yet still have the arrows viewable. Is this possible to do so? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to keep the drop down arrow on data lists when not selecte
If you need any further assistance just post back.
-- Biff Microsoft Excel MVP "Diamondgirl" wrote in message ... Darn... not quite what I wanted to hear, but I'll try it. Yes, these are pretty basic lists; therefore the combo box might have to be the trick. Thank you for your quick response! "T. Valko" wrote: If you use a combo box from the Forms toolbar the drop arrow is always visible however, a combo box acts a bit differently than a data validation drop down list. If you use the selected item in formulas then it's slightly more complicated but simple once you learn how to do it. -- Biff Microsoft Excel MVP "Diamondgirl" wrote in message ... I have data validations set up in a worksheet, and I want to be able to tab off the lists, and yet still have the arrows viewable. Is this possible to do so? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down Lists: Allow option of adding own data if not in drop do | Excel Worksheet Functions | |||
| How to verify selected data from drop-down list? | Excel Worksheet Functions | |||
| How do I add data to drop down lists? | Excel Worksheet Functions | |||
| Data Validation - Drop-down list - make arrow visible at all times | Excel Discussion (Misc queries) | |||
| return a data list depending on a value selected within a drop dow | Excel Discussion (Misc queries) | |||
Linear Mode
