HI

This was working before and I have not idea where to start.

What happens is as soon as the textbox1 changes it runs the code below

Private Sub TextBox1_Change()
If correct = 1 Then Exit Sub
TextBox1.Text = UCase(TextBox1.Text)
End Sub

it keeps saying "compile error can't find project or library." an
highlights UCASE

any idea why is can't find what every it wants

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=38708

What had happened was I created this in Excel 97 and took it home t
work on Excel 2000 and some how when I saved it it changed th
reference which was pointing the the outlook 98 reference to look a
outlook 9 reference. I discovered this by openning up reference unde
the tools part in VBE and saw a reference starting with MISSING
unticked it and then select the correct version I am using now it i
working once again

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=38708

funkymonkUK,
Check the ToolsReferences for a "MISSING".
May be the cause of your dr. watson error also.

NickHK

"funkymonkUK"
wrote in message
...

HI

This was working before and I have not idea where to start.

What happens is as soon as the textbox1 changes it runs the code below

Private Sub TextBox1_Change()
If correct = 1 Then Exit Sub
TextBox1.Text = UCase(TextBox1.Text)
End Sub

it keeps saying "compile error can't find project or library." and
highlights UCASE

any idea why is can't find what every it wants?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=387081

This is usually caused by a missing reference,

In the VB IDE, goto menu ToolsReferences, and you should see a checked item
that start with MISSING. Make a note of which library it is, uncheck it,
exit and re-test.

If you get problems later, you might need to find the correct version of
that library.

--
HTH

Bob Phillips

"funkymonkUK"
wrote in message
...

HI

This was working before and I have not idea where to start.

What happens is as soon as the textbox1 changes it runs the code below

Private Sub TextBox1_Change()
If correct = 1 Then Exit Sub
TextBox1.Text = UCase(TextBox1.Text)
End Sub

it keeps saying "compile error can't find project or library." and
highlights UCASE

any idea why is can't find what every it wants?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=387081