Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi. I want to animate a menu bar that is floating in Excel and flies in from
left to right. This is the code where I attemped to do it, but the screen isn't updated properly. How can I have a better visual look here. Thanks for helping. CODE SNIPPET: ------------------ Sub MENU_Makro3() Dim myBar As CommandBar Dim i As Integer ' Set myBar = CommandBars("My Menu") With myBar .Position = msoBarFloating .Top = 245 ' Wants to animate the menu bar flying in from Left For i = 35 To 600 .Left = i Next i End With ' Unfortuneately you can hardly se the Menu Bar moving. Why is that??? End Sub Regards Jan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
Custom Menu return to Excel Menu upon Closing | Excel Programming | |||
Free animating ActiveX control | Excel Programming |