||edit: creating in the Office 2003 VB editor
Good evening all,
I'm new to visual basic so I thank anyone for whatever help you have for me. I am creating a form that runs on the opening of a Word template. The form takes the text in the fields and inserts them into their assigned bookmarks.
What I am trying to do is create either a combobox item or split listing with a multiline string of text.
For example,
I would like the combobox to display as an option
Jet1
Jet2
Jet3
And when Jet1 is selected it would insert something similar to the below:
Aircraft Aviation Business Jets Charter, LLC l Charter Services
Chicago Sales Office l 6150 South Laramie Avenue l Chicago, IL 60638 l USA
Tel. +1 773 581 9448 | +1 800 232 5388 l Fax +1 201 624 7338 l www.site.com
I've tried tweaking the below code but I don't know how to break the text into multiple lines.
CODE
aStateList = Split(" AL AK AS AZ AR CA CO CT DE DC FM FL GA GU" _
& " HI ID IL IN IA KS KY LA ME MH MD MA MI MN MS" _
& " MO MT NE NV NH NJ NM NY NC ND MP OH OK OR PW" _
& " PA PR RI SC SD TN TX UT VT VI VA WA WV WI WY")
Me.ComboBox1.List = aStateList
End Sub
Any help would be greatly appreciated. Thanks!
This post has been edited by mpretico: 16 Jun, 2008 - 05:13 PM