Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to list all validation cells on a sheet
hello,
i understand how to alter a validation drop down box using vb. how is it possible to list using vb all validations drop downs that appear on a sheet? Cheers |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to list all validation cells on a sheet
Hi
To count ALL validation cells: MsgBox Worksheets("Feuil2").Cells.SpecialCells(xlCellType AllValidation).Count BUT if you have different Validation types it will include all of them. HTH Cordially Pascal "HCS" a écrit dans le message de ... hello, i understand how to alter a validation drop down box using vb. how is it possible to list using vb all validations drop downs that appear on a sheet? Cheers |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to list all validation cells on a sheet
have a look at vba help for SpecialCells method it has 2 modes to either select "AllValidation" or "SameValidation" and automates what you could manually do via Goto Special keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "HCS" wrote: hello, i understand how to alter a validation drop down box using vb. how is it possible to list using vb all validations drop downs that appear on a sheet? Cheers |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to list all validation cells on a sheet
Please watch for unwanted carriage return:
MsgBox _ Worksheets("Feuil2").Cells.SpecialCells(xlCellType AllValidation).Count Cordially Pascal "papou" a écrit dans le message de ... Hi To count ALL validation cells: MsgBox Worksheets("Feuil2").Cells.SpecialCells(xlCellType AllValidation).Count BUT if you have different Validation types it will include all of them. HTH Cordially Pascal "HCS" a écrit dans le message de ... hello, i understand how to alter a validation drop down box using vb. how is it possible to list using vb all validations drop downs that appear on a sheet? Cheers |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to list all validation cells on a sheet
Thanks to both of you that looks like what i need!
Cheers "keepITcool" wrote in message ... have a look at vba help for SpecialCells method it has 2 modes to either select "AllValidation" or "SameValidation" and automates what you could manually do via Goto Special keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "HCS" wrote: hello, i understand how to alter a validation drop down box using vb. how is it possible to list using vb all validations drop downs that appear on a sheet? Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation list form sheet | Excel Worksheet Functions | |||
Data Validation List from different sheet | Excel Discussion (Misc queries) | |||
Validation,........how to use a list in another sheet | Excel Worksheet Functions | |||
List Validation Based on another sheet | Excel Discussion (Misc queries) | |||
Remove empty cells from named list / validation list | Excel Worksheet Functions |