Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Script for Drop Down Menu
i some kind person gave me the code below to insert into my spreadsheet to
remove the white space from my drop down menus. the issue is that i have 15 of these on the same page. can i just copy and paste the same codes below the first (changing names and fields of course), or do i need to make a new module? Please advise. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim t, List For t = 18 To 24 If Cells(t, "H") < "" Then List = List & "," & Cells(t, "H") Next With Range("H2").Validation .Delete .Add xlValidateList, Formula1:=List .InCellDropdown = True End With End Sub Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you creat a drop down menu in excel? | Excel Discussion (Misc queries) | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
Check box and a drop down menu in Excel | Excel Discussion (Misc queries) | |||
How do u insert a drop down menu in a Excel | Excel Worksheet Functions | |||
how do i create drop down menu in excel | Excel Worksheet Functions |