| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button Problem with the Sort command
Hope this takes this time.
I have on sheet 1 a button that I have attached code to that is suppose to sort data on sheet 2, sheet 3, sheet 4, well it is not working. So I'm asking for help in trying to figure out what I'm doing wrong. On sheet 1 the code is: Private Sub Main Button 1() Sheets ("Sheet 1").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 Sheets ("Sheet 2").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 Sheets ("Sheet 3").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 End Sub ================= Private Sub Sort1() Selection.Sort Key1:=Range("B1"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal End Sub ================= |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button Problem with the Sort command
Sorry met to let you folks know that I'm working in Excel 2003
"michdenis" wrote: Hi, Your code should be working fine ! I suppose you have a Excel 1997 version and the button you are using to trigger your macro comes from the control tool bar. If my guest is right, in creation mode, modify the property "TakeFocusOnClic" of the button to False. This is a well known bug. "caldog" a écrit dans le message de groupe de discussion : ... Hope this takes this time. I have on sheet 1 a button that I have attached code to that is suppose to sort data on sheet 2, sheet 3, sheet 4, well it is not working. So I'm asking for help in trying to figure out what I'm doing wrong. On sheet 1 the code is: Private Sub Main Button 1() Sheets ("Sheet 1").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 Sheets ("Sheet 2").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 Sheets ("Sheet 3").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 End Sub ================= Private Sub Sort1() Selection.Sort Key1:=Range("B1"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal End Sub ================= |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button Problem with the Sort command
Your code is working with Excel 2007.
Did you put your code in a general module ? "caldog" a écrit dans le message de groupe de discussion : ... Sorry met to let you folks know that I'm working in Excel 2003 "michdenis" wrote: Hi, Your code should be working fine ! I suppose you have a Excel 1997 version and the button you are using to trigger your macro comes from the control tool bar. If my guest is right, in creation mode, modify the property "TakeFocusOnClic" of the button to False. This is a well known bug. "caldog" a écrit dans le message de groupe de discussion : ... Hope this takes this time. I have on sheet 1 a button that I have attached code to that is suppose to sort data on sheet 2, sheet 3, sheet 4, well it is not working. So I'm asking for help in trying to figure out what I'm doing wrong. On sheet 1 the code is: Private Sub Main Button 1() Sheets ("Sheet 1").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 Sheets ("Sheet 2").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 Sheets ("Sheet 3").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 End Sub ================= Private Sub Sort1() Selection.Sort Key1:=Range("B1"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal End Sub ================= |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button Problem with the Sort command
I beleive that I'm. I use the macro recorder, then assign the code generated
to the button. This is my process when I'm attaching code to a button. The error message that I'm getting is: The sort reference is not valid. Make sure that it's within the data you want to sort, and the Sort By box isn't the same or blank" "michdenis" wrote: Your code is working with Excel 2007. Did you put your code in a general module ? "caldog" a écrit dans le message de groupe de discussion : ... Sorry met to let you folks know that I'm working in Excel 2003 "michdenis" wrote: Hi, Your code should be working fine ! I suppose you have a Excel 1997 version and the button you are using to trigger your macro comes from the control tool bar. If my guest is right, in creation mode, modify the property "TakeFocusOnClic" of the button to False. This is a well known bug. "caldog" a écrit dans le message de groupe de discussion : ... Hope this takes this time. I have on sheet 1 a button that I have attached code to that is suppose to sort data on sheet 2, sheet 3, sheet 4, well it is not working. So I'm asking for help in trying to figure out what I'm doing wrong. On sheet 1 the code is: Private Sub Main Button 1() Sheets ("Sheet 1").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 Sheets ("Sheet 2").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 Sheets ("Sheet 3").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 End Sub ================= Private Sub Sort1() Selection.Sort Key1:=Range("B1"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal End Sub ================= |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button Problem with the Sort command
an example : http://cjoint.com/?bmfrwVxLkB
"caldog" a écrit dans le message de groupe de discussion : ... I beleive that I'm. I use the macro recorder, then assign the code generated to the button. This is my process when I'm attaching code to a button. The error message that I'm getting is: The sort reference is not valid. Make sure that it's within the data you want to sort, and the Sort By box isn't the same or blank" "michdenis" wrote: Your code is working with Excel 2007. Did you put your code in a general module ? "caldog" a écrit dans le message de groupe de discussion : ... Sorry met to let you folks know that I'm working in Excel 2003 "michdenis" wrote: Hi, Your code should be working fine ! I suppose you have a Excel 1997 version and the button you are using to trigger your macro comes from the control tool bar. If my guest is right, in creation mode, modify the property "TakeFocusOnClic" of the button to False. This is a well known bug. "caldog" a écrit dans le message de groupe de discussion : ... Hope this takes this time. I have on sheet 1 a button that I have attached code to that is suppose to sort data on sheet 2, sheet 3, sheet 4, well it is not working. So I'm asking for help in trying to figure out what I'm doing wrong. On sheet 1 the code is: Private Sub Main Button 1() Sheets ("Sheet 1").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 Sheets ("Sheet 2").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 Sheets ("Sheet 3").Select ActiveSheet.Range ("A1:D45").Select Call Sort1 End Sub ================= Private Sub Sort1() Selection.Sort Key1:=Range("B1"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal End Sub ================= |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a command button problem | Excel Programming | |||
| Command Button Problem | Excel Discussion (Misc queries) | |||
| Problem with command button name | Excel Discussion (Misc queries) | |||
| Problem programming the Sort command | Excel Programming | |||
| Command Button Problem | Excel Programming | |||
Hybrid Mode
