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

Re: combobox list by Greg

Greg
Thu Jan 17 05:44:23 PST 2008

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?

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

"Seapup" <Seapup@discussions.microsoft.com> wrote in message
news:4E7A4632-43DA-4A11-9168-C569470E1F77@microsoft.com...
> 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



Re: combobox list by Seapup

Seapup
Thu Jan 17 07:06:02 PST 2008

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" wrote:

> 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?
>
> --
> Greg Maxey/Word MVP
> See:
> http://gregmaxey.mvps.org/word_tips.htm
> For some helpful tips using Word.
>
> "Seapup" <Seapup@discussions.microsoft.com> wrote in message
> news:4E7A4632-43DA-4A11-9168-C569470E1F77@microsoft.com...
> > 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
>
>
>

Re: combobox list by Greg

Greg
Thu Jan 17 07:17:31 PST 2008

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.

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


Seapup wrote:
> 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" wrote:
>
>> 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?
>>
>> --
>> Greg Maxey/Word MVP
>> See:
>> http://gregmaxey.mvps.org/word_tips.htm
>> For some helpful tips using Word.
>>
>> "Seapup" <Seapup@discussions.microsoft.com> wrote in message
>> news:4E7A4632-43DA-4A11-9168-C569470E1F77@microsoft.com...
>>> 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