|
-
Aug 17th, 2005, 09:27 AM
#1
Thread Starter
New Member
Combo Boxes in Excel
Hello, I need some help writing the appropriate code to move and stop my combo box in Excel. The code below shows my recorded macro that moves my combo box a certain increment; however, if you hit the macro button on the Excel screen it continues to move the box by that increment. What I want is to be able to have it move only once, and then stop, or have the code to create a origin for my combo box pulldown. Any suggestions?
Sub NewMacro1()
'
' NewMacro1 Macro
' Macro recorded 8/15/2005 by e0062010
'
'
Application.Run "Proto1.xls!Default2"
ActiveSheet.Shapes("Drop Down 133").Select
Selection.ShapeRange.IncrementLeft -90#
Range("A16").Select
End Sub
Sub NewMacro2()
'
' NewMacro2 Macro
' Macro recorded 8/15/2005 by e0062010
'
'
Application.Run "Proto1.xls!Custom"
ActiveSheet.Shapes("Drop Down 133").Select
Selection.ShapeRange.IncrementLeft 90#
Range("A9").Select
End Sub
Last edited by Aron40; Aug 17th, 2005 at 09:32 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|