Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If ...Then Statement
Group,
I have a worksheet change evenet that I want to be able to toggle with a named cell value. Private Sub Worksheet_Change(ByVal Target As Range) If dailyupdate = True Then SortThem End Sub NO errors, but it doesn't run.......I am totally lost as to how to fix it.... I know there is something missing If the value is false, I want it to just fail and stop. Please help :) Thanks in advance..... Scottie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If ...Then Statement
Maybe...
Private Sub Worksheet_Change(ByVal Target As Range) If me.range("dailyupdate").value = True Then SortThem End Sub DailyUpdate is a named range (single cell) on the same sheet? Scottie wrote: Group, I have a worksheet change evenet that I want to be able to toggle with a named cell value. Private Sub Worksheet_Change(ByVal Target As Range) If dailyupdate = True Then SortThem End Sub NO errors, but it doesn't run.......I am totally lost as to how to fix it.... I know there is something missing If the value is false, I want it to just fail and stop. Please help :) Thanks in advance..... Scottie -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
If ...Then Statement
actually it is on a seperate sheet called "setup"
"Dave Peterson" wrote: Maybe... Private Sub Worksheet_Change(ByVal Target As Range) If me.range("dailyupdate").value = True Then SortThem End Sub DailyUpdate is a named range (single cell) on the same sheet? Scottie wrote: Group, I have a worksheet change evenet that I want to be able to toggle with a named cell value. Private Sub Worksheet_Change(ByVal Target As Range) If dailyupdate = True Then SortThem End Sub NO errors, but it doesn't run.......I am totally lost as to how to fix it.... I know there is something missing If the value is false, I want it to just fail and stop. Please help :) Thanks in advance..... Scottie -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If ...Then Statement
A WORKSHEET_change event works on changing something on the worksheet of the
macro module. So..... -- Don Guillett Microsoft MVP Excel SalesAid Software "Scottie" wrote in message ... actually it is on a seperate sheet called "setup" "Dave Peterson" wrote: Maybe... Private Sub Worksheet_Change(ByVal Target As Range) If me.range("dailyupdate").value = True Then SortThem End Sub DailyUpdate is a named range (single cell) on the same sheet? Scottie wrote: Group, I have a worksheet change evenet that I want to be able to toggle with a named cell value. Private Sub Worksheet_Change(ByVal Target As Range) If dailyupdate = True Then SortThem End Sub NO errors, but it doesn't run.......I am totally lost as to how to fix it.... I know there is something missing If the value is false, I want it to just fail and stop. Please help :) Thanks in advance..... Scottie -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
If ...Then Statement
Dave,
Using your structure...I managed to figure it out... but is it correctly done? Private Sub Worksheet_Change(ByVal Target As Range) If Worksheets("Setup").Range("dailyupdate").Value = True Then SortThem End Sub Thanks "Dave Peterson" wrote: Maybe... Private Sub Worksheet_Change(ByVal Target As Range) If me.range("dailyupdate").value = True Then SortThem End Sub DailyUpdate is a named range (single cell) on the same sheet? Scottie wrote: Group, I have a worksheet change evenet that I want to be able to toggle with a named cell value. Private Sub Worksheet_Change(ByVal Target As Range) If dailyupdate = True Then SortThem End Sub NO errors, but it doesn't run.......I am totally lost as to how to fix it.... I know there is something missing If the value is false, I want it to just fail and stop. Please help :) Thanks in advance..... Scottie -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
If ...Then Statement
The code is under the worksheet that holds the DailyUpdate cell?
And the subroutine called SortThem sorts the other worksheet? Without seeing that SortThem macro (and how the data is laid out), it might be perfect--or it could be bad <vbg. Did it work correctly for you? If yes, then I'd say it was perfect! If no, then post back with the details of the SortThem macro and a little info on how that data is laid out. Scottie wrote: Dave, Using your structure...I managed to figure it out... but is it correctly done? Private Sub Worksheet_Change(ByVal Target As Range) If Worksheets("Setup").Range("dailyupdate").Value = True Then SortThem End Sub Thanks "Dave Peterson" wrote: Maybe... Private Sub Worksheet_Change(ByVal Target As Range) If me.range("dailyupdate").value = True Then SortThem End Sub DailyUpdate is a named range (single cell) on the same sheet? Scottie wrote: Group, I have a worksheet change evenet that I want to be able to toggle with a named cell value. Private Sub Worksheet_Change(ByVal Target As Range) If dailyupdate = True Then SortThem End Sub NO errors, but it doesn't run.......I am totally lost as to how to fix it.... I know there is something missing If the value is false, I want it to just fail and stop. Please help :) Thanks in advance..... Scottie -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
If ...Then Statement
Dave,
I actually posted that code in here because I knew one of you guys would spot the problem right away and correct me :) The SortThem procedure works fine and yes it actually sorts 3 other worksheets, and now it does it based on a flag in my setup sheet. I suppose I could have said that in the first case. I don't think I really want to embarass myself further by showing you that code also...I really have no idea what I am doing. I learn the code from google and the macro recorder, so I don't understand all concepts :) But thanks ... it works and I learned how Scottie "Dave Peterson" wrote: The code is under the worksheet that holds the DailyUpdate cell? And the subroutine called SortThem sorts the other worksheet? Without seeing that SortThem macro (and how the data is laid out), it might be perfect--or it could be bad <vbg. Did it work correctly for you? If yes, then I'd say it was perfect! If no, then post back with the details of the SortThem macro and a little info on how that data is laid out. Scottie wrote: Dave, Using your structure...I managed to figure it out... but is it correctly done? Private Sub Worksheet_Change(ByVal Target As Range) If Worksheets("Setup").Range("dailyupdate").Value = True Then SortThem End Sub Thanks "Dave Peterson" wrote: Maybe... Private Sub Worksheet_Change(ByVal Target As Range) If me.range("dailyupdate").value = True Then SortThem End Sub DailyUpdate is a named range (single cell) on the same sheet? Scottie wrote: Group, I have a worksheet change evenet that I want to be able to toggle with a named cell value. Private Sub Worksheet_Change(ByVal Target As Range) If dailyupdate = True Then SortThem End Sub NO errors, but it doesn't run.......I am totally lost as to how to fix it.... I know there is something missing If the value is false, I want it to just fail and stop. Please help :) Thanks in advance..... Scottie -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
If ...Then Statement
Glad you got it working.
But you've got to develop a thicker skin <vbg. You'll soon learn to say "thanks for the help" and maybe walk away with code that's a little easier to understand. It's something that can make you more efficient in your coding, too. Every once in awhile, I'll visit the .worksheet.functions newsgroup. I truly believe that some of those people have brains that just work differently than me (and most normal people!). I'll post my do this and then do that and try this. And then one of those smart guys/gals will come in and say: Or you could just use.... Embarrassing? Not as much as before <bg. I just hope my post ages off really quickly. Scottie wrote: Dave, I actually posted that code in here because I knew one of you guys would spot the problem right away and correct me :) The SortThem procedure works fine and yes it actually sorts 3 other worksheets, and now it does it based on a flag in my setup sheet. I suppose I could have said that in the first case. I don't think I really want to embarass myself further by showing you that code also...I really have no idea what I am doing. I learn the code from google and the macro recorder, so I don't understand all concepts :) But thanks ... it works and I learned how Scottie "Dave Peterson" wrote: The code is under the worksheet that holds the DailyUpdate cell? And the subroutine called SortThem sorts the other worksheet? Without seeing that SortThem macro (and how the data is laid out), it might be perfect--or it could be bad <vbg. Did it work correctly for you? If yes, then I'd say it was perfect! If no, then post back with the details of the SortThem macro and a little info on how that data is laid out. Scottie wrote: Dave, Using your structure...I managed to figure it out... but is it correctly done? Private Sub Worksheet_Change(ByVal Target As Range) If Worksheets("Setup").Range("dailyupdate").Value = True Then SortThem End Sub Thanks "Dave Peterson" wrote: Maybe... Private Sub Worksheet_Change(ByVal Target As Range) If me.range("dailyupdate").value = True Then SortThem End Sub DailyUpdate is a named range (single cell) on the same sheet? Scottie wrote: Group, I have a worksheet change evenet that I want to be able to toggle with a named cell value. Private Sub Worksheet_Change(ByVal Target As Range) If dailyupdate = True Then SortThem End Sub NO errors, but it doesn't run.......I am totally lost as to how to fix it.... I know there is something missing If the value is false, I want it to just fail and stop. Please help :) Thanks in advance..... Scottie -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions |