Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,236
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't figure this out... jmj713 Excel Discussion (Misc queries) 8 April 11th 09 02:33 AM
HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE Nad.Engoor Excel Worksheet Functions 3 December 30th 08 03:04 PM
Can't figure this out!!! Tilleyswife Excel Worksheet Functions 3 November 9th 06 06:21 PM
Can't figure out Mark Jackson Excel Worksheet Functions 1 September 4th 06 04:39 PM
Still trying to figure it out Robertgn Excel Worksheet Functions 2 December 10th 05 12:44 PM


All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"