Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by adam228
-
Excel - Bespoke Dropdown Entry
Thanks for the correction. But then how to refer(in formula1 parameter) to the list of items which are in another sheet ? I've tried but Excel wouldn't allow. Also I've tried comma-delimited syntax like this: formula1:="Teacher1,Teacher2,...,Teacher30" where the list contains 30...- adam228
- Post #7
- Forum: Microsoft: Office
-
Excel - Bespoke Dropdown Entry
This is a follow-up question, not an answer. I've tried to code using macro to make a drop-down list and the "formula1" argument refers to the list items put in a range of cells(A1:A7) in a worksheet like this way: Sub x() With Range("e5").Validation .Add...- adam228
- Post #5
- Forum: Microsoft: Office
