combobox list

[Seapup]

I'm a rookie at VBA

How do I show the symbol " within a drop down list
the symbol is a double quote I'm trying to show it as inches without typing
the word inch after each number

 

[Greg Maxey]

You can do it like this:
Private Sub UserForm_Initialize()
ComboBox1.AddItem "1" & Chr(34)
'or
ComboBox1.AddItem "2"""
End Sub

Does "Seapup" signify any experience at sea?

 

[Seapup]

Thanks that did the trick for me.

No had no experience at sea. I'm just trying to swim the vast ocean of VBA
programming.

 

[Greg Maxey]

With 30 years in the Navy (a former life), I might be considered a seadog or
even and old seadog. Sailors new to shipboard life were often called
seapups.