PDA

View Full Version : VBA newbie need help on error



neanea
07-12-2009, 12:22 AM
error object required. Can someone help me to fix this?
Do While 0 < Count
If Task.Finish > DateTime.Now Then
Font Color:=1
End If
Loop

mdmackillop
07-13-2009, 12:40 AM
Step through the code to determine the actual error. Use the Watch window to check values. My guess is you need to define what Font refers to.

Bob Phillips
07-13-2009, 04:20 AM
Can you post you project with a small explanation of how you invoke the code?