ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Include Blank Value In Validation List (https://www.excelbanter.com/excel-programming/405458-include-blank-value-validation-list.html)

born2achieve

Include Blank Value In Validation List
 
hi, i have two sheets in workbook named as shtbiz,shtbiz1.
so column A of my shtbiz1 sheet i have 100 datas.the by using following code
i can fill the datas of shtbiz1 in column A of shtbiz.
code:

Code:
Dim strValItems
strValItems = ""
Dim rngValList As Range, rngValCell As Range
Set rngValList = ShtBiz1.Range("A6", Range("A10000").End(xlUp))
With ShtBiz.Range("A6:A10000")
.Validation.Delete
For Each rngValCell In rngValList
If Len(strValItems) 0 Then strValItems = strValItems & ","
strValItems = strValItems & rngValCell.Value

Next
.Validation.Add xlValidateList, , , strValItems
End With

so my problem is i need to add blank value in the top of the list .ie first
value should be blank then other values which read from shtbiz1 has to be
followed.so please help me to include one blank value at the to pof my
validation list please


All times are GMT +1. The time now is 09:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com