Hello,
I'm currently using the following type of vba coding for a drop down list:
'Set validation for Colums "c" to "Ag"
With ws.Columns.Range("c5:Ag41").Validation
.Delete
.Add xlValidateList, xlValidAlertStop, xlBetween, "JF,BS,8F,DO,XX,X,4xx/4TR,4TR/xx,8H,7.5H,4H/XX,4v"
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = True
.ReadingOrder = xlContext
.MergeCells = False
End With
What I'm trying to accomplish is to be able to insert a keyboard symbol (alt, 31) in front of "4V" at the end of the drop down list identified above. I'd also like to add another symbol (alt, 30) in front of another "4V", which I'd have to add to my drop down list. So the end product with symbols would look like ▲4v and ▼4v. If I try to paste this into the visual basic window I get the following: ?4v
Any assistance would be greatly appreciated if this is even possible.
Bookmarks