I don't want to fire up the button, I just want to read the text that
is in its centre. It is one of a large number of buttons on a webite,
of which this is one:
"InnerText" I hadn't thought of, but it isn't that. It isn't "Value"
or "Text". A "Record Macro" of the text being edited looks like this
(no mention of the edit itself):
Sub Macro1()
ActiveSheet.Shapes("Control 1").Select
Selection.Verb Verb:=xlPrimary
End Sub
Nor is it "Verb" or "Characters" or anything to do with "Interior".
In the unlikely event you would like to see one of these buttons, they
are the left hand "Data" column if you insert two dates into this
website. Paste a few rows into Excel, and the button forms thus
cunningly "hiding" the data - you can look at it but you cannot
process it!
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.