Excel, Pick from Drop down list and VB
Visual Basic
1
Posts
1
Posters
0
Views
1
Watching
-
Anyone know how.... Have a sheet (sA) with a list of names pulled from a database. On second sheet (sB), need to set the cells in one of the columns to be a picklist based on the names on sA. Am OK with selecting a range etc, but don't know how to programmatically tell Excel that the values in the cells on sB need to appear in a drop-down made from sA Anyone got any ideas - 'tis driving me wappy! "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox