Add a space to list validation

[huutri]

Hi All

I have problem about list datavalidation: I want to add a space in first row of list validation, I try use chr(32) but it doesn't show any space. Can i help you add a space to first row in list datavalidation? Thanks

 

[Jaafar Tribak]

Hi All

I have problem about list datavalidation: I want to add a space in first row of list validation, I try use chr(32) but it doesn't show any space. Can i help you add a space to first row in list datavalidation? Thanks

make the DV list refer to a range whose the first cell is blank .

 

[huutri]

Thank you for your answer
But in DV list i get data from multi ranges, and i want to add empty row at the first row of list. I try use chr(32) but excel doesn't accept blank for a row. This is my code:

kg = Chr(32)
kq = kq & ", Item 1" & ", Item 2"

With com_code.validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:=kg
.IgnoreBlank = False
.InCellDropdown = True
.InputTitle = "Options"
.ErrorTitle = ""
'.InputMessage = "Click yes or no"
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With

 

[crazypabs]

try replacing the chr$(32) with " "

 

[huutri]

Thank for your reply
I tried use " " to replace chr(32) but excel doesn't accept empty row contain " ". Now, i use text to replace space.

Thank all