![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#2
|
||||
|
||||
|
In the userform code
Code:
Option Explicit
Private Sub btnSave_Click()
Dim oRng As Range
If cmbColour.ListIndex >= 0 Then
With ActiveDocument
On Error GoTo lbl_Exit
If .Bookmarks.Exists("My_Colour") = True Then
Set oRng = .Bookmarks("My_Colour").Range
oRng.Text = cmbColour.Value
oRng.Bookmarks.Add "My_Colour"
End If
End With
Else
MsgBox "Select Colour", vbCritical
End If
Unload Me
lbl_Exit:
Set oRng = Nothing
Exit Sub
End Sub
Private Sub UserForm_Initialize()
Dim i As Integer
Dim sColour As String
With ActiveDocument
If .Bookmarks.Exists("My_Colour") = True Then
sColour = .Bookmarks("My_Colour").Range.Text
End If
End With
With cmbColour
.AddItem "Red"
.AddItem "Green"
.AddItem "Blue"
For i = 0 To .ListCount - 1
If sColour = .List(i) Then
.ListIndex = i
Exit For
End If
Next i
End With
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 |
| bookmarks reference field, combo box, default values |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| UserForm with Combo Box from data in table within template | jhansrod | Word VBA | 6 | 06-13-2019 09:02 AM |
Multi-select Combo Box with Item Descriptions
|
SLAB8002 | Excel Programming | 3 | 05-30-2019 12:27 PM |
| Pasting a table with combo boxes to a new document looses the combo box | bobsut@enviro-consult.com | Word | 1 | 01-03-2017 01:29 PM |
| Userform without inserting Bookmark text | mktate | Word VBA | 8 | 12-31-2015 01:11 PM |
Moving Selected Items from a Multiselect Listbox on a userform to a bookmark in Word
|
marksm33 | Word VBA | 3 | 01-15-2015 07:55 PM |