![]() |
|
#1
|
|||
|
|||
|
I am making a form that I want to auto populate if the names have already been put in at some other point. I am using comboboxes to populate the prefixes of the names such as Mr.|Ms.|Dr. etc using a Split () array. How can I make my combobox set default as the variable and still keep the rest of the list available? For some reason, my code only wants me to have either the list or the variable, not both.
Private Sub UserForm_Initialize() Dim myPrefixes() As String myPrefixes = Split(" |Mr. |Ms. |Dr.", "|") Prefix1.List = myPrefixes End Sub |
| Tags |
| vba combobox |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Excel Combobox List
|
VBA-User | Excel Programming | 4 | 01-07-2016 02:46 AM |
| Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge | Berryblue | Mail Merge | 1 | 11-13-2014 05:36 PM |
combobox list gets reset....please help
|
Deepa Shrestha | Word VBA | 1 | 09-29-2013 09:30 PM |
Adding a long list of values to a combobox in Word 2003?
|
ll4u76 | Word VBA | 1 | 04-13-2012 03:37 AM |
Populating ComboBox or Drop Down list with contents of a text field
|
Billy_McSkintos | Word VBA | 1 | 09-13-2011 05:50 AM |