Hello, subject. How can I to do it ? thanks.
A:
I'm not sure about the 2010 interface, in 2003 you'd go to the Validation dialog and add a List check.
In code that'd be:
columns(1).validation.add xlValidateList,,,"yes,no"
GSerg
2010-06-21 18:28:08
In excel 2010 it doesn't work I found how to put combobox into one cell but how to put into all cells of one column have not found :(.For one cell needs to enable Developer Tab in Excel 2010 and insert combobox from this tab.
jitm
2010-06-22 08:00:21