-
Apr 4th, 2012, 01:18 AM
#1
Thread Starter
Hyperactive Member
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
-
Apr 4th, 2012, 01:56 AM
#2
Junior Member
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?
-
Apr 4th, 2012, 02:10 AM
#3
Re: Excel chart area textbox text value
if posible attach the file.
-
Apr 4th, 2012, 05:50 PM
#4
Thread Starter
Hyperactive Member
Re: Excel chart area textbox text value
Originally Posted by MorDred
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.
Originally Posted by seenu_1st
if posible attach the file.
Not going to happen due to information privacy and size of the beast.
-
Apr 4th, 2012, 07:13 PM
#5
Junior Member
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.
-
Apr 7th, 2012, 12:19 PM
#6
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
-
Apr 9th, 2012, 11:00 AM
#7
New Member
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.
-
Apr 18th, 2012, 11:36 PM
#8
Thread Starter
Hyperactive Member
Re: Excel chart area textbox text value
Originally Posted by Jon Peltier
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|