MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Reg Shapes

  Asked By: Mali    Date: Sep 20    Category: MS Office    Views: 1384

I am trying to make kind of presentation in excel. It wud be something
like this. I draw 5 round rectangle, 1 in the middle(Head) and 4
around them (branch of the head)These branch would be further
subdivided into several other.
When i take my mouse over the centre shape the 4 others should appear
else they should be hidden.I tried using mouseover event but it dosent



4 Answers Found

Answer #1    Answered By: Rosa Reynolds     Answered On: Sep 20

1) Please show your code and also indicate which module you put it in.

2) Exactly which control did you use to create your "round rectangle"?
toolbar did you get it from?

3) Are you drawing this directly on a worksheet or in a form?

Answer #2    Answered By: Geldefsman Bakker     Answered On: Sep 20

I took the shape  from a drawing toolbar and applied it on a sheet

Private Sub RoundedRectangle1_MouseMove(ByVal Button As Integer, ByVal
Shift As Integer, ByVal X As Single, ByVal Y As Single)
End Sub

Answer #3    Answered By: Von Fischer     Answered On: Sep 20

Here's a quick and dirty way to show some shapes  etc...


Answer #4    Answered By: Lenora Green     Answered On: Sep 20

I've done a bit of a Google search and am not finding information on using
MouseMove with AutoShapes. Where did you get your information from? If you
point me at it, I'll have a play.

Didn't find what you were looking for? Find more on Reg Shapes Or get search suggestion and latest updates.