> Hi
> I have created a geographical map with different provinces in Excel 2003. I
[quoted text clipped - 8 lines]
> Regards
> Gideon
I made a simple map with 6 shapes grouped together, renamed the group
MyMap and renamed each shape (Adelaide, Brisbane, Darwin, Melbourne,
Perth and Sydney). Each shape was separately assigned to the same
macro...
Sub Cap_City()
UserForm1.TextBox1.Value = Application.Caller
End Sub
The userform (UserForm1) has its ShowModal property set to False and
has 2 textboxes (TextBox1 and TextBox2) with the following
TextBox_Enter code...
Private Sub TextBox1_Enter()
ActiveSheet.Shapes("MyMap").Visible = True
End Sub
Private Sub TextBox2_Enter()
ActiveSheet.Shapes("MyMap").Visible = False
End Sub
When textbox1 is entered MyMap appears and when MyMap is clicked the
appropriate city name appears inside it.
When TextBox2 is entered MyMap disappears.
So I guess the answer to your question is yes.
Ken Johnson
Max - 13 May 2008 00:15 GMT
Ken,
Could you provide a link here to d/l your sample book?
I'd like to learn how that works. Thanks.

Signature
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Ken Johnson - 13 May 2008 02:02 GMT
> Ken,
> Could you provide a link here to d/l your sample book?
[quoted text clipped - 4 lines]
> xdemechanik
> ---
Hi Max,
It's a bare bones workbook I cobbled together just to test the
possibility.
I will email you a copy.
Ken Johnson
Max - 13 May 2008 04:15 GMT
Thanks, Ken

Signature
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---