Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to indicate a cell has a validation list associated to it?
Excel 2002...I have several cells that have Validation lists associated
within them. When I select the cell I see the indictor that there is a list attached. I want to know if there is a way to indicate that there is a list atached to all th cells without having to selct the cells....so that somone coming up on the spreadsheet will know just by looking which cells have lists associated with them. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to indicate a cell has a validation list associated to it?
Mike,
A simple solution may be to just add a selection like <Select One to your data validation list and have that populate the cells when the workbook is opened. Thanks, Mark "Mike" wrote: Excel 2002...I have several cells that have Validation lists associated within them. When I select the cell I see the indictor that there is a list attached. I want to know if there is a way to indicate that there is a list atached to all th cells without having to selct the cells....so that somone coming up on the spreadsheet will know just by looking which cells have lists associated with them. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to indicate a cell has a validation list associated to it?
Hi as far as I know, the only way to do this, without using Vba, is to place a control (a combo box) in the worksheet. Open the Forms toolbar, select the combo box control, place it in the desired position in the worksheet. Then you have to define the range for the list and the link cell. You can see this post to have an idea of the technique http://jldexcel.blogspot.com/2006/03...orksheets.html In a near future I will post about using combo boxes in worksheets w/o Vba. -- jordun ------------------------------------------------------------------------ jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118 View this thread: http://www.excelforum.com/showthread...hreadid=530094 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation List Advise Please | New Users to Excel | |||
Data Validation and Blanks in List | Excel Worksheet Functions | |||
HOW DO I MAKE VALIDATION LIST CONTAING DATA FROM A DIFFERENT BO | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |