Results 1 to 10 of 10

ContentControl Listbox - Get selected "Value" instead of "Display Text"

Threaded View

  1. #1
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    ContentControl Listbox - Get selected "Value" instead of "Display Text"

    2 values are set up for each Listbox list item
    - Display text
    - Value
    The value displayed for user selection is "Display Text", and after selection it is also the "Display Text"

    My macro also extracts the selected "Display Text", but I want the other "value" (see the picture)
    What is the correct syntax to use to get at the other value?

    Sub SelectedValues()
        Dim cc As ContentControl
        For Each cc In Me.ContentControls
            
            Debug.Print cc.Range.Text
            
        Next cc
    End Sub
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. Display "TEXT" in "Values" field in PIVOT TABLE using VBA!!
    By meus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-05-2015, 09:56 AM
  3. Display "TEXT" in "Values" field in PIVOT TABLE using VBA!!
    By meus in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-04-2015, 06:14 AM
  4. Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  5. Replies: 0
    Last Post: 03-21-2014, 09:58 AM
  6. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  7. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1