Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Data Validations
Hi Jase,
Not sure exactly what you're asking for, but data validation and cell formatting are independent features. You can apply cell formatting and data validation to the same cell, but you can't control cell formatting in any way using data validation. You also can't control the formatting of a list displayed by the data validation feature. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Jase" wrote in message ... Hi Guys I have code that creates a basic data validation, and that part works. However I have discovered that I am unable to bring the formatting of my cells into the validations does anyone know of a way to either bring in the format of the cells or of another type of object that I can use to create a list with formatting in it (and preferably assign that list to a cell). Thanks heaps Jase |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validations | Excel Worksheet Functions | |||
2 Data Validations Q | Excel Worksheet Functions | |||
two data validations for same cell | Excel Discussion (Misc queries) | |||
data validations | Excel Discussion (Misc queries) | |||
3 data validations | Excel Worksheet Functions |