Results 1 to 8 of 8

Thread: Excel chart area textbox text value

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2007
    Location
    Godzone, oops Oz
    Posts
    355

    Excel chart area textbox text value

    Well this one has me stumped.

    Am looking at a spreadsheet someone else has developed and cannot find where the text value is being assigned to a textbox

    Anyone know how to determine the textbox's name and view it's details.

    TIA
    http://www.scaryminds.com - Horror's last colonial outpost.

  2. #2
    Junior Member
    Join Date
    Apr 2012
    Posts
    20

    Re: Excel chart area textbox text value

    What version of Excel? If 2007 or higher, is the textbox an ActiveX textbox or is it a userform?

  3. #3
    Just a Member! seenu_1st's Avatar
    Join Date
    Aug 2007
    Location
    India
    Posts
    2,170

    Re: Excel chart area textbox text value

    if posible attach the file.
    Seenu

    If this post is useful, pls don't forget to Rate this post.
    Pls mark thread as resolved once ur problem solved.
    ADO Tutorial Variable types SP6 for VB6, MsFlexGrid fast fill, Sorting Algorithms


  4. #4

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2007
    Location
    Godzone, oops Oz
    Posts
    355

    Re: Excel chart area textbox text value

    Quote Originally Posted by MorDred View Post
    What version of Excel? If 2007 or higher, is the textbox an ActiveX textbox or is it a userform?
    That would be MS Office 10 as the thread title would suggest

    Am thinking it's an ActiveX, but all the ActiveX controls are greyed out, surprising neither the sheet nor workbook appear to be locked.

    Quote Originally Posted by seenu_1st View Post
    if posible attach the file.
    Not going to happen due to information privacy and size of the beast.
    http://www.scaryminds.com - Horror's last colonial outpost.

  5. #5
    Junior Member
    Join Date
    Apr 2012
    Posts
    20

    Re: Excel chart area textbox text value

    Hi KiwiDexter, try the following procedure
    Code:
    Sub FindObjects()
        Dim Ws As Worksheet
        Dim obj As OLEObject
        Dim objRng As Range
        
        For Each Ws In Sheets
            For Each obj In Ws.OLEObjects
                obj.Visible = True
                If MsgBox("The object name is: " & obj.Name & vbNewLine _
                    & "Press OK to continue to next object or Cancel to veiw selected object", vbOKCancel) = vbCancel Then
                        obj.Select
                        Exit Sub
                End If
            Next obj
        Next Ws
        
    End Sub
    Last edited by MorDred; Apr 4th, 2012 at 07:20 PM.

  6. #6
    Discovering Life Siddharth Rout's Avatar
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    12,001

    Re: Excel chart area textbox text value

    >>> Not going to happen due to information privacy and size of the beast.

    Can you post a screenshot of that textbox?
    A good exercise for the Heart is to bend down and help another up...
    Please Mark your Thread "Resolved", if the query is solved


    MyGear:
    ★ CPU ★ Ryzen 5 5800X
    ★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
    ★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
    ★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
    ★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
    ★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
    ★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
    ★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
    ★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
    ★ Keyboard ★ TVS Electronics Gold Keyboard
    ★ Mouse ★ Logitech G502 Hero

  7. #7
    New Member Jon Peltier's Avatar
    Join Date
    Oct 2011
    Location
    Massachusetts
    Posts
    4

    Re: Excel chart area textbox text value

    Disabled ActiveX ribbon buttons could be because of your security settings being too high, or because, as the title suggests, you've selected a chart.

    If the textbox is in a chart, then it is a plain old textbox from the Shapes menu. If it is linked to a cell, you can find the link by (1) clicking on the textbox, so the textbox is selected but there is no cursor in the text, then (2) looking at the formula bar.

  8. #8

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2007
    Location
    Godzone, oops Oz
    Posts
    355

    Re: Excel chart area textbox text value

    Quote Originally Posted by Jon Peltier View Post
    Disabled ActiveX ribbon buttons could be because of your security settings being too high, or because, as the title suggests, you've selected a chart.

    If the textbox is in a chart, then it is a plain old textbox from the Shapes menu. If it is linked to a cell, you can find the link by (1) clicking on the textbox, so the textbox is selected but there is no cursor in the text, then (2) looking at the formula bar.
    Great idea, will try that in a few minutes

    http://www.scaryminds.com - Horror's last colonial outpost.

Posting Permissions

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



Click Here to Expand Forum to Full Width