ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I figure out what I need to do.... (https://www.excelbanter.com/excel-programming/286166-how-do-i-figure-out-what-i-need-do.html)

Phillips[_2_]

How do I figure out what I need to do....
 
I had a system chrash and when I restored and then ran my worksheet, I get
errors when running the userform.

Here is the line that traps the error:

If Time < ActiveCell.Offset(0, 74) And Time < ActiveCell.Offset(0, 75)
Then

It appears that "Time" is not valid, but I am not sure what library was
linked that had this. This HAD worked on the previous system. I tried to
relink all that I had before...


For furture reference, is there a way to create a "check list" or an install
that will allow me to ensure that all refeences are included?

Help!!!

TIA



Rob van Gelder[_4_]

How do I figure out what I need to do....
 
From VBA, Go to Tools | References.
Check to make sure nothing says "MISSING: "

You can also try to export the form, then read the content in Notepad to
give you a clue about what it was using.


"Phillips @recycledreefs.com" <phil<nospam wrote in message
news:CC6Gb.641785$Fm2.573208@attbi_s04...
I had a system chrash and when I restored and then ran my worksheet, I get
errors when running the userform.

Here is the line that traps the error:

If Time < ActiveCell.Offset(0, 74) And Time < ActiveCell.Offset(0, 75)
Then

It appears that "Time" is not valid, but I am not sure what library was
linked that had this. This HAD worked on the previous system. I tried to
relink all that I had before...


For furture reference, is there a way to create a "check list" or an

install
that will allow me to ensure that all refeences are included?

Help!!!

TIA






All times are GMT +1. The time now is 07:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com