vba help needed Sharepoint

[Dublin Irish]

Hi All,

Im wondering could you help Im looking to have multiple selections from a dropdown list in a single cell, I was able to implement it using VBA but I didn't realise I can't use macrons on Sharepoint online.

Is there another way of me doing this without using VBA ? Ive attached the vba code below I was using.

Thank in advance



Private Sub Worksheet_Change(ByVal Target As Range)

Dim Oldvalue As String

Dim Newvalue As String



On Error GoTo Exitsub

If Target.Column >= 10 And Target.Column <= 300 Then

If Target.SpecialCells(xlCellTypeAllValidation) Is Nothing Then

GoTo Exitsub

Else: If Target.Value = "" Then GoTo Exitsub Else

Application.EnableEvents = False

Newvalue = Target.Value

Application.Undo

Oldvalue = Target.Value

If Oldvalue = "" Then

Target.Value = Newvalue

Else

Target.Value = Oldvalue & ", " & Newvalue

End If

End If

End If

Application.EnableEvents = True

Exitsub:

Application.EnableEvents = True

End Sub

 

[Fluff]

Is there another way of me doing this without using VBA ?

Not that I'm aware of.