0
I would like to have the data validation that is possible with having a dropdown but I would like to have more than one selection.
Is is possible for a cell dropdown to have checkboxes beside the dropdown elements?
0
I would like to have the data validation that is possible with having a dropdown but I would like to have more than one selection.
Is is possible for a cell dropdown to have checkboxes beside the dropdown elements?
1
Instead of Dropdown box, List box is best suitable to add Check boxes for multiple selection.
Let me explain how to do this in Excel (most of Excel commands & methods are applicable to Google Sheet also.)
How it works:
Insert the below written code as Module.
Sub Rectangle2_Click()
Dim xSelShp As Shape, xSelLst As Variant, I As Integer
Set xSelShp = ActiveSheet.Shapes(Application.Caller)
Set xLstBox = ActiveSheet.ListBox1
If xLstBox.Visible = False Then
xLstBox.Visible = True
xSelShp.TextFrame2.TextRange.Characters.Text = "Click After Pickup Options"
Else
xLstBox.Visible = False
xSelShp.TextFrame2.TextRange.Characters.Text = "Click To Select Options"
For I = xLstBox.ListCount - 1 To 0 Step -1
If xLstBox.Selected(I) = True Then
xSelLst = xLstBox.List(I) & "," & xSelLst
End If
Next I
If xSelLst <> "" Then
Range("ListBoxOutput") = Mid(xSelLst, 1, Len(xSelLst) - 1)
Else
Range("ListBoxOutput") = ""
End If
End If
End Sub
E155
.Note, adjust cell references for Source item list, List box, Shape's position & for Output cell also.
Gald to help you Gabriel,,, keep asing ☺ – Rajesh S – 2018-09-17T05:36:44.103