![]() |
#7
|
||||
|
||||
![]()
Personally I would leave out the spaces and add the space when you write to the document variable e.g.
Code:
Private Sub UserForm_Initialize() Dim myPrefixes() As String Dim strPrefix As String Dim i As Integer myPrefixes = Split("[Select Item]|Mr.|Ms.|Det.|Dr.|Atty.|Rabbi|Ofc.|Sgt.|Cpl.|Maj.", "|") With Prefix1 .List = myPrefixes On Error Resume Next 'the variable is missing from the document For i = 0 To .ListCount - 1 If RTrim(ActiveDocument.Variables("Prefix")) = .List(i) Then .ListIndex = i Exit For End If Next i End With End Sub Private Sub CommandButton1_Click() If Prefix1.ListIndex <= 0 Then MsgBox "Select the prefix" Prefix1.SetFocus Exit Sub End If ActiveDocument.Variables("Prefix") = Prefix1.value & Chr(32) Unload Me End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
Tags |
vba combobox |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
Deepa Shrestha | Word VBA | 1 | 09-29-2013 09:30 PM |
![]() |
ll4u76 | Word VBA | 1 | 04-13-2012 03:37 AM |
![]() |
Billy_McSkintos | Word VBA | 1 | 09-13-2011 05:50 AM |