Thread
:
If ...Then Statement
View Single Post
#
6
Posted to microsoft.public.excel.programming
Scottie
external usenet poster
Posts: 16
If ...Then Statement
That seems correct Don, but can't it call something else? For example .....
another procedure?
"Don Guillett" wrote:
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
Reply With Quote
Scottie
View Public Profile
Find all posts by Scottie