AM using following code snippet
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="a,b,c"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
But am getting error Expression expected on line 2 ie is on Add Type. But after removing ":" no error is displayed. But while executin runtime error is occuirng which says: Suntax error.
Will appreciate the response on this.
I am trying to create a list box(combo box) in excel cell at runtime which will contain list of values captured at runtime from any browser based application. But some how this code is not working. I have searched lot of forums regarding this, but unable to get the answer. Will appreciate your response. Thanks.