Hi Hilary,
You seem to already have the answer :)
If you assign the following macro to your listbox, the text in the callout
will be updated correctly:
Sub ListBox1_Change()
Dim wb As Workbook
Set wb = ThisWorkbook
With wb.Worksheets("Ratio")
.Shapes("Rectangular Callout 1").TextFrame.Characters.Text = _
wb.Worksheets("interpretation").Cells(.Cells(1, 1).Value, 1).Value
End With
Set wb = Nothing
End Sub
Best to remove the cell link fro mthe shape, and there is now no need for
the formula at interpretation!A14.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of hilary lomotey
Sent: Thursday, April 05, 2012 8:49 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Amount of words in Rectangular Shape box
problem
I have seen the code he used, i think its
Sub ListBox1_Change()
Sheet2.Shapes("shpMyShape").TextFrame.Characters.Text = Sheet1.Range("A24")
End Sub
On Thu, Apr 5, 2012 at 3:20 PM, dguillett1 <dguille...@gmail.com> wrote:
How?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma <mailto:rajanverma1...@gmail.com>
Sent: Thursday, April 05, 2012 8:03 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Amount of words in Rectangular Shape box
problem
Hi please find the attached sheet
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of hilary lomotey
Sent: Apr/Thu/2012 05:21
To: excel-macros
Subject: $$Excel-Macros$$ Amount of words in Rectangular Shape box problem
Good Afternoon Experts
In the file attached, i am trying to achieve a situation where if i click
one of the members in the list box , the interpretation of the of the word
would appear in the rectangular shape box. the problem is that , i cant seem
to see all the explanation in the rectangular shape box when i click the
word. i tried to reduce the font but without success. is there a way to have
all the explanation of the word appear in the box? thanks
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
