Hello All,
I have searched the internet and do not think this is possible...I need to use a data validation list using two rows of input data. I cannot create another row (or column) of data with the two rows combined. The way my data is set up, I have in row 17 a code (we'll call it department code) and in row 18 another code (we'll call it department). I would like the drop down list to list the department code and the department in the same list box. I can use VBA to do this if necessary.
Below is the code I used to create the data validation list:
Any suggestions would be much appreciated!
K
I have searched the internet and do not think this is possible...I need to use a data validation list using two rows of input data. I cannot create another row (or column) of data with the two rows combined. The way my data is set up, I have in row 17 a code (we'll call it department code) and in row 18 another code (we'll call it department). I would like the drop down list to list the department code and the department in the same list box. I can use VBA to do this if necessary.
Below is the code I used to create the data validation list:
Code:
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=DD5_Curve"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
Any suggestions would be much appreciated!
K