combobox list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Seapup - 17 Jan 2008 13:31 GMT

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

Reply to this Message

Greg Maxey - 17 Jan 2008 13:44 GMT

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?

Signature

Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

> 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

Reply to this Message

Seapup - 17 Jan 2008 15:06 GMT

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. :)

> You can do it like this:
> Private Sub UserForm_Initialize()
[quoted text clipped - 11 lines]
> > typing
> > the word inch after each number

Reply to this Message

Greg Maxey - 17 Jan 2008 15:17 GMT

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.

Signature

Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

> Thanks that did the trick for me.
>
[quoted text clipped - 22 lines]
>>> typing
>>> the word inch after each number

Reply to this Message