I have an excel sheet inside my VB application. I need to make a drop down box for selections.
The code to make the drop down, according to the VBA inside Excel is:
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
Only problem, is inside VB, it does not recognize "xlValidateList" or "xlValidAlertStop" or "xlBetween"
It IS clunky having to use Excel inside VB, but unfortunatly i need it.
I have the following references:
What am i missing?