Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 08-29-2021, 04:19 AM
gmayor's Avatar
gmayor gmayor is offline how to select a default value for a combo in a userform from value of bookmark in the word document Windows 10 how to select a default value for a combo in a userform from value of bookmark in the word document Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply With Quote
 

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
how to select a default value for a combo in a userform from value of bookmark in the word document 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
how to select a default value for a combo in a userform from value of bookmark in the word document 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft