Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code that allows users to pick multiple choices from a
data validation list. The problem with the code is that users can pick multiple choices from all the lists in the worksheet and not just F, J, V, O. How can I change this to only allow users to choose multiple items in those columns? Thanks. If Application.Intersect(Target, Range("F2:F25,U2:U25,V2:V25,02:025")) Is Nothing Then Exit Sub For Each cell In Target Application.EnableEvents = False On Error GoTo exitHandler newVal = cell.Value Application.Undo oldVal = cell.Value cell.Value = newVal If oldVal = "" Then 'do nothing Else If newVal = "" Then 'do nothing Else cell.Value = oldVal _ & ";# " & newVal End If End If Next cell exitHandler: Application.EnableEvents = True |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pick multiple items in data validation | Excel Discussion (Misc queries) | |||
Choosing multiple items in a drop down list | Excel Discussion (Misc queries) | |||
data validation from multiple lists | Excel Programming | |||
Choosing multiple items in a dropdown menu | Excel Programming | |||
Printing Multiple Data Validation Lists | Excel Worksheet Functions |