Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a drop down list, where the user can more than 1 answer
I know how to create a drop down list, however, I am trying to create a
tracking worksheet where users can select as many responses that apply. Any ideas? -- Willow1221 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a drop down list, where the user can more than 1 answer
See DV0017 in:
http://www.contextures.on.ca/excelfiles.html#DataVal -- Gary''s Student - gsnu200903 "Willow1221" wrote: I know how to create a drop down list, however, I am trying to create a tracking worksheet where users can select as many responses that apply. Any ideas? -- Willow1221 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a drop down list, where the user can more than 1 answer
Thank you. This does show me what can be done, however, I am unable to locate
instructions for how to apply this. Any guidance? -- Willow1221 "Willow1221" wrote: I know how to create a drop down list, however, I am trying to create a tracking worksheet where users can select as many responses that apply. Any ideas? -- Willow1221 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a drop down list, where the user can more than 1 answer
Here is the code from DV0017, paste it in a sheet module. Look for line
wrap which I believe I see in the "iCol=Cells..." line. Make sure it is all on one line. Put your data Validation cell (or cells) in column C. This complies with the "If Target.Column = 3 Then..." code OR change the "3" in the code to the column you want and install your data validation('s) in that column. (A=1, B=2 etc.) Now as you select from the Data Validation the choices will be listed to the right of the Validation cell in that row. In the example shown in DV0017 the yellow cells all have Data Validation in them and you can choose a yellow cell and select various choices in the respective drop-downs and see how they become listed to the right of each cell. Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo exitHandler Dim rngDV As Range Dim iCol As Integer If Target.Count 1 Then GoTo exitHandler On Error Resume Next Set rngDV = Cells.SpecialCells(xlCellTypeAllValidation) On Error GoTo exitHandler If rngDV Is Nothing Then GoTo exitHandler If Intersect(Target, rngDV) Is Nothing Then 'do nothing Else Application.EnableEvents = False If Target.Column = 3 Then If Target.Value = "" Then GoTo exitHandler If Target.Validation.Value = True Then iCol = Cells(Target.Row, Columns.Count).End(xlToLeft).Column + 1 Cells(Target.Row, iCol).Value = Target.Value Else MsgBox "Invalid entry" Target.Activate End If End If End If exitHandler: Application.EnableEvents = True End Sub HTH Regards, Howard "Willow1221" wrote in message ... I know how to create a drop down list, however, I am trying to create a tracking worksheet where users can select as many responses that apply. Any ideas? -- Willow1221 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a drop down list, where the user can more than 1 answer
http://boisgontierjacques.free.fr/pa...hoixSuccessifs JB http://boisgontierjacques.free.fr On 12 sep, 00:43, Willow1221 wrote: I know how to create a drop down list, however, I am trying to create a tracking worksheet where users can select as many responses that apply. Any ideas? -- Willow1221 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a drop down list, where the user can more than 1 answer
Hi Gary"s Student,
I tried to adjust this line of code to list the selections vertical instead of horizontal and was unable to come up with the correct syntax. I bonked...! iCol = Cells(Target.Row, Columns.Count).End(xlToLeft).Column + 1 Regards, Howard "Willow1221" wrote in message ... I know how to create a drop down list, however, I am trying to create a tracking worksheet where users can select as many responses that apply. Any ideas? -- Willow1221 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form - Get Data From Drop List | Excel Discussion (Misc queries) | |||
How do I make my list name for drop down box conditional on user e | Excel Discussion (Misc queries) | |||
Trying to add a drop down list of all worksheets for the user | Excel Discussion (Misc queries) | |||
Can a user select more than one entry in a drop down list? | Excel Worksheet Functions | |||
A user says he can't get my drop down list to work in Excel. | Excel Discussion (Misc queries) |