Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel VBA first timer
SkipVought I did change the code to the WORKSHEET object area for sheet2 and now I am getting a compile error telling me that ScheduleCheck() is not defined. ScheduleCheck() is in the Workbook code because I want multiple sheets to run it in the end so do I have to do something in sheet2 code...- Ashrum145
- Post #10
- Forum: Microsoft: Office
-
Excel VBA first timer
xlbo the code is as pasted in the Workbook section of code. I tried to put the Workbook_Change code in the Sheet2 code section but I could not get it to call ScheduleCheck from there.- Ashrum145
- Post #8
- Forum: Microsoft: Office
-
-
Excel VBA first timer
No change, if I run the program manually it works but will still not run on a change :( Why would the double negatives work different than without?- Ashrum145
- Post #3
- Forum: Microsoft: Office
-
Excel VBA first timer
I'm trying to ge the following code to run on a change in Sheet2 but the thing does not work. Sub ScheduleCheck() RowNumber = 2 Do While Not (IsEmpty(Sheet2.Cells(RowNumber, 3))) SchedRow = 2 Do While Not (IsEmpty(Sheet1.Cells(SchedRow, 2))) If...- Ashrum145
- Thread
- Replies: 10
- Forum: Microsoft: Office
