Thread: UCASE problem
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default UCASE problem

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