VBA Excel - What cell does this refer to?
Posted on 2014-01-17
I have some moderate knowledge of VBA - not great tho!
I am trying to fix something for a colleague.
At this moment, I cannot upload the sheet onto EE.
Specifically, I need help with the following line;
If (Sheet1.DTBox2.Value - Sheet1.DTBox.Value < 0) Then
I understand that it is comparing two dates etc.
However, where do I find the value for Sheet1.STBox2.value ?
1. Should I be looking in some cell on sheet1?
2. Should I be looking in the "Names Manager"?
3. The workbook is fairly complex and perhaps there are external links