Results 1 to 2 of 2

Thread: Combo Boxes in Excel

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 2005
    Posts
    1

    Exclamation 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
  •  



Click Here to Expand Forum to Full Width