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.
I would like the combobox to display as an option
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.
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 June 2008 - 06:13 PM