+ Reply to Thread
Results 1 to 3 of 3

Display object properties box for textbox, Display list of objects in workbook

  1. #1
    Forum Contributor
    Join Date
    02-05-2015
    Location
    czech
    MS-Off Ver
    2010
    Posts
    172

    Display object properties box for textbox, Display list of objects in workbook

    Is it possible display object properties? I'm able to display Properties box for sheets (in the designer menu).
    I would like to display properties of texbox. Mainly I would like to find out the name of selected texbox.

    Is there a box which lists every object in workbook or sheet?

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Display object properties box for textbox, Display list of objects in workbook

    Good evening jakopak
    Quote Originally Posted by jakopak View Post
    Is there a box which lists every object in workbook or sheet?
    Niope. 'fraid not.

    However, Allen Wyatt has done the hard bit and written a VBA routine that will list all objects by name, and return the type of object.
    You can find his article here.

    HTH

    DominicB

  3. #3
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Display object properties box for textbox, Display list of objects in workbook

    Hi jakopak,

    Nice link DominicB. Thank you for sharing.

    You can put the following Macro in your PERSONAL workbook. Select a Shape, then run the Macro (ALT F8), if macros are enabled.

    To enable Macros and to Run Macros see the following:
    http://office.microsoft.com/en-us/ex...010031071.aspx
    http://office.microsoft.com/en-us/ex...010014113.aspx
    If help is still needed do a google search for 'youtube excel enable macro' and/or 'youtube excel run macro'.

    To access the PERSONAL Workbook see: https://support.office.com/en-nz/art...0-6e4c3f5ee566


    Please Login or Register  to view this content.
    Lewis

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel 2010 - Userform - display date from textbox in a label or textbox in 'ddd' format
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2015, 10:54 PM
  2. Search textbox value in a different workbook and display other column values in userform
    By SierraKilo78 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2014, 01:29 PM
  3. Cannot Display Tooltip in Properties
    By BLLMRC in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2013, 08:19 PM
  4. [SOLVED] Display a Object from Non Value List
    By zplugger in forum Excel General
    Replies: 4
    Last Post: 12-05-2012, 06:23 PM
  5. Replies: 2
    Last Post: 05-21-2007, 01:47 PM
  6. Workbook Protection of Display Size and Properties
    By cpadude in forum Excel General
    Replies: 1
    Last Post: 03-04-2007, 11:49 PM
  7. Can I display the file properties of a workbook in a custom headi.
    By Sings4Fun in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-16-2005, 01:06 PM

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