Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a drop down list with a multitude of entries selected
Hi,
Is it possible to create a drop down list in Excel where you could "check" a multitude of entries from the list? When you would view the drop down list you would see all the entries that have been selected. For example if I had a drop down list showing when a certain task is being done (ie. daily, weekly, monthly, annualy, etc.) the user would have the possibility to select more than one option in the list and a check mark would appear next to it for example. Your help is greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a drop down list with a multitude of entries selected
Hi,
You need a macro to do this for you. Try the following code which will put the contents of a dropdown list into the cell to the right. Change the Target.Offset values to alter the position. Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim rngDV As Range If Target.Count 1 Then GoTo exitHandler Application.EnableEvents = False 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 If Target.Value = "" Then GoTo exitHandler If Target.Offset(0, 1).Value = "" Then Target.Offset(0, 1).Value = Chr(149) & Target.Value Else Target.Offset(0, 1).Value = _ Target.Offset(0, 1).Value _ & Chr(10) & Chr(149) & Target.Value End If End If exitHandler: Application.EnableEvents = True End Sub Dave "run2live" wrote: Hi, Is it possible to create a drop down list in Excel where you could "check" a multitude of entries from the list? When you would view the drop down list you would see all the entries that have been selected. For example if I had a drop down list showing when a certain task is being done (ie. daily, weekly, monthly, annualy, etc.) the user would have the possibility to select more than one option in the list and a check mark would appear next to it for example. Your help is greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I add to a drop down list after I have selected it? | Excel Discussion (Misc queries) | |||
Creating a list with entries from cells and manual entry too | Excel Discussion (Misc queries) | |||
How many entries can be put into a drop down list in excel? | Excel Worksheet Functions | |||
Value selected on drop down list, look-up on different sheet | Excel Worksheet Functions | |||
Searching a list with repeat entries and creating a sum | Excel Discussion (Misc queries) |