ComboBox (using Commas)

Status
Not open for further replies.
S

srm

I'm using O2003, creating a custom form, using the combo box control.

I want to add multiple values but within those values I want to use

commas. For example

This is value number 1, and it has a comma

This is value number 2, and it has a comma

However, Outlook thinks the comma is a new entry and it lists the

items as follows:

This is value number 1

and it has a comma

This is value number 2

and it has a comma

It there a way to add entry using a comma as part of the entry?

Thank you.

Shawn
 
S

Sue Mosher [MVP]

You would need to use code in the form's Item_Open event handler. See

http://www.outlookcode.com/article.aspx?ID=32 for a sample form.

Sue Mosher

"srm" <srm@primatech.com> wrote in message

news:3d96ff92-e3e6-432b-8ab5-5172ccd0ae74@g1g2000vbr.googlegroups.com...
> I'm using O2003, creating a custom form, using the combo box control.
> I want to add multiple values but within those values I want to use
> commas. For example

> This is value number 1, and it has a comma
> This is value number 2, and it has a comma

> However, Outlook thinks the comma is a new entry and it lists the
> items as follows:

> This is value number 1
> and it has a comma
> This is value number 2
> and it has a comma

> It there a way to add entry using a comma as part of the entry?

> Thank you.

> Shawn
 
S

srm

On Sep 1, 11:57 am, "Sue Mosher [MVP]" <sue...@turtleflock.com> wrote:
> You would need to use code in the form's Item_Open event handler. Seehttp://www.outlookcode.com/article.aspx?ID=32for a sample form.
> > Sue Mosher
>    >      >    
> "srm" <s...@primatech.com> wrote in message

> news:3d96ff92-e3e6-432b-8ab5-5172ccd0ae74@g1g2000vbr.googlegroups.com...
>
> > I'm using O2003, creating a custom form, using the combo box control.
> > I want to add multiple values but within those values I want to use
> > commas. For example

>
> > This is value number 1, and it has a comma
> > This is value number 2, and it has a comma

>
> > However, Outlook thinks the comma is a new entry and it lists the
> > items as follows:

>
> > This is value number 1
> > and it has a comma
> > This is value number 2
> > and it has a comma

>
> > It there a way to add entry using a comma as part of the entry?

>
> > Thank you.

>
> > Shawn


Sue:

Thank you. I don't want to take too much of your time. I got this to

appear on a test form in the "General" and "P.2" tab, but not my

custom form "General" or "P.2" tab. I see the drop down, but no data.

I' think I'm past my capability of coding at this point. I still

cannot get it to accept the commas and I'm not a big coder. Am I close

or over my head at this point and need to look at other options?

Function Item_Open()

' Sets the name of page on the form (General)

Set FormPage = Item.GetInspector.ModifiedFormPages("General")

' Sets Control to a combo box called ComboBox1.

Set Control = FormPage.Controls("ComboBox1")

' Assign values to the combo box.

Control.PossibleValues = "Blue;Green;Red;Yellow"

End Function

Shawn
 
S

Sue Mosher [MVP]

You should never use PossibleValues in code. Did you look at the sample form

on the I suggested? It shows exactly how to load rows into a list box or

combo box from a delimited string.

Sue Mosher

"srm" <srm@primatech.com> wrote in message

news:99794827-deb2-4e7f-a664-05f4418a0974@o13g2000vbl.googlegroups.com...

On Sep 1, 11:57 am, "Sue Mosher [MVP]" <sue...@turtleflock.com> wrote:


> You would need to use code in the form's Item_Open event handler.
> Seehttp://www.outlookcode.com/article.aspx?ID=32for a sample form.

> "srm" <s...@primatech.com> wrote in message

> news:3d96ff92-e3e6-432b-8ab5-5172ccd0ae74@g1g2000vbr.googlegroups.com...
>
> > I'm using O2003, creating a custom form, using the combo box control.
> > I want to add multiple values but within those values I want to use
> > commas. For example

>
> > This is value number 1, and it has a comma
> > This is value number 2, and it has a comma

>
> > However, Outlook thinks the comma is a new entry and it lists the
> > items as follows:

>
> > This is value number 1
> > and it has a comma
> > This is value number 2
> > and it has a comma

>
> > It there a way to add entry using a comma as part of the entry?

>
> > Thank you.

>
> > Shawn


Sue:

Thank you. I don't want to take too much of your time. I got this to

appear on a test form in the "General" and "P.2" tab, but not my

custom form "General" or "P.2" tab. I see the drop down, but no data.

I' think I'm past my capability of coding at this point. I still

cannot get it to accept the commas and I'm not a big coder. Am I close

or over my head at this point and need to look at other options?

Function Item_Open()

' Sets the name of page on the form (General)

Set FormPage = Item.GetInspector.ModifiedFormPages("General")

' Sets Control to a combo box called ComboBox1.

Set Control = FormPage.Controls("ComboBox1")

' Assign values to the combo box.

Control.PossibleValues = "Blue;Green;Red;Yellow"

End Function

Shawn
 
S

srm

On Sep 1, 2:00 pm, "Sue Mosher [MVP]" <sue...@turtleflock.com> wrote:
> You should never use PossibleValues in code. Did you look at the sample form
> on the I suggested? It shows exactly how to load rows into a list box or
> combo box from a delimited string.
> > Sue Mosher
>    >      >    
> "srm" <s...@primatech.com> wrote in message

> news:99794827-deb2-4e7f-a664-05f4418a0974@o13g2000vbl.googlegroups.com...
> On Sep 1, 11:57 am, "Sue Mosher [MVP]" <sue...@turtleflock.com> wrote:

>
> > You would need to use code in the form's Item_Open event handler.
> > Seehttp://www.outlookcode.com/article.aspx?ID=32fora sample form.

>
> > "srm" <s...@primatech.com> wrote in message

>
> >news:3d96ff92-e3e6-432b-8ab5-5172ccd0ae74@g1g2000vbr.googlegroups.com...

>
> > > I'm using O2003, creating a custom form, using the combo box control.
> > > I want to add multiple values but within those values I want to use
> > > commas. For example

>
> > > This is value number 1, and it has a comma
> > > This is value number 2, and it has a comma

>
> > > However, Outlook thinks the comma is a new entry and it lists the
> > > items as follows:

>
> > > This is value number 1
> > > and it has a comma
> > > This is value number 2
> > > and it has a comma

>
> > > It there a way to add entry using a comma as part of the entry?

>
> > > Thank you.

>
> > > Shawn


> Sue:

> Thank you. I don't want to take too much of your time. I got this to
> appear on a test form in the "General" and "P.2" tab, but not my
> custom form "General" or "P.2" tab. I see the drop down, but no data.
> I' think I'm past my capability of coding at this point. I still
> cannot get it to accept the commas and I'm not a big coder. Am I close
> or over my head at this point and need to look at other options?

> Function Item_Open()

>    ' Sets the name of page on the form (General)
>    Set FormPage = Item.GetInspector.ModifiedFormPages("General")

>    ' Sets Control to a combo box called ComboBox1.
>    Set Control = FormPage.Controls("ComboBox1")

>    ' Assign values to the combo box.
>    Control.PossibleValues = "Blue;Green;Red;Yellow"

> End Function

> Shawn


Sue:

Thank you. I will check the page again. I appreciate your time.

Shawn
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
S Dynamically add recipients using combobox and checkbox????? Using Outlook 2
C Trying to populate an appointment ComboBox from Excel Outlook VBA and Custom Forms 2
N Select Appointment subject line from combobox or list Outlook VBA and Custom Forms 1
C Autofill subject line in appointment from options selected in combobox Using Outlook 6
B Contact Page 2 Combobox via Registry Outlook VBA and Custom Forms 6
N Combobox in outlook add ons toolbar not firing event on main window resized Using Outlook 3
J userform combobox Outlook VBA and Custom Forms 1
R combobox list in userform Outlook VBA and Custom Forms 1
K Alignment in Combobox Outlook VBA and Custom Forms 1
P Setting combobox properties from Outlook 2007 Add-in Outlook VBA and Custom Forms 9
K Adding watermark to Combobox in Outlook. Outlook VBA and Custom Forms 1
C ComboBox data Outlook VBA and Custom Forms 2
D ComboBox with Multi columns Outlook VBA and Custom Forms 4
E Where is the best place to store values for combobox entries Outlook VBA and Custom Forms 5
E Where is the best place to store values for combobox entries Outlook VBA and Custom Forms 5
A Going to folder using shortcuts Using Outlook 3
A Outlook replies not using "delivered to" address in From Using Outlook 1
Terry Sullivan E-Mails Sent Using a Group Box Result in 70 Kickbacks Using Outlook 5
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
K Using Outlook 2016 to draw Using Outlook 1
O Outlook 365 - suddenly unable to send using Gmail POP3 Using Outlook 10
N Disable Auto Read Receipts sent after using Advanced Find Using Outlook 4
G Outlook 2016 sync contacts directly between phone and computer using outlook 2016 Using Outlook 0
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
O Save attachments using hotkey without changing attributes Outlook VBA and Custom Forms 1
J Add an Attachment Using an Array and Match first 17 Letters to Matching Template .oft to Send eMail Outlook VBA and Custom Forms 2
A Edit subject - and change conversationTopic - using VBA and redemption Outlook VBA and Custom Forms 2
A Using or not using apostrophes in search terms has this changed? Using Outlook 0
O Office 365 using POP3 on both laptop and desktop Using Outlook 0
M Using field names to capture a data element Using Outlook 0
B Vba to monitor time to respond to emails using a shared mailbox Outlook VBA and Custom Forms 5
B Looking to get the Recipient email address (or even the "friendly name") from an email I am replying to using VBA Outlook VBA and Custom Forms 4
D Using a VBA Custom Form to Send Reoccurring Email Upon Task Completion Outlook VBA and Custom Forms 4
Z Adding dropdown list using custom form Outlook VBA and Custom Forms 7
O Using .OST and .PST mail thru different providers Using Outlook 5
N Open & Save VBAProject.Otm using VBA Code Outlook VBA and Custom Forms 1
D Remove text in subject using VBA Outlook VBA and Custom Forms 4
P How to export voting results using VBA? Outlook VBA and Custom Forms 2
E Using the Like operator properly Outlook VBA and Custom Forms 1
R Using "check for duplicates" for existing contacts Using Outlook 2
S Find a cell value in excel using outlook vba Using Outlook 1
N Using email notification to update calendar events? Outlook VBA and Custom Forms 4
S Macro using .SendUsingAccount only works the first time, after starting Outlook Outlook VBA and Custom Forms 4
C Sync Calendars using WiFI Using Outlook 3
A Capturing Send Variables without using Application_ItemSend in ThisOutlookSession Outlook VBA and Custom Forms 8
L Using alpha numeric in email address Using Outlook 5
Sabastian Samuel HOW DO I FORWARD AN EMAIL WITH MACRO using an email that in the body of another email Outlook VBA and Custom Forms 3
D create an html table in outlook custom form 2010 using vba in MsAccess Outlook VBA and Custom Forms 7
D Print Attachments only in selected emails using a macro Outlook VBA and Custom Forms 3
B query outlook using vba Outlook VBA and Custom Forms 13
Similar threads


















































Top