| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation (Drop down list vs simple text length validation)
One has Data Validation applied to it, the other doesn't See
http://www.contextures.com/xlDataVal01.html -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Jac Tremblay" wrote in message ... Hi everyone, I want to know how to distinguish between a cell that displays a drop down list in a cell and another that does not. Thank you. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validation (Drop down list vs simple text length validation)
Not necessarily.
Check the InCellDropdown property of the Validation object Range("A1").Validation.InCellDropDown will be True or False. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Bob Phillips" wrote in message ... One has Data Validation applied to it, the other doesn't See http://www.contextures.com/xlDataVal01.html -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Jac Tremblay" wrote in message ... Hi everyone, I want to know how to distinguish between a cell that displays a drop down list in a cell and another that does not. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple drop down list validation | New Users to Excel | |||
| Data Validation List Length | Excel Worksheet Functions | |||
| Text size in validation drop-down list box | Excel Worksheet Functions | |||
| validation list drop down box, how do I bring in text commands | Excel Discussion (Misc queries) | |||
| data validation list drop down text format too small | Excel Worksheet Functions | |||
![Bob Phillips[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
