converting a variable to uppercase.

Hey,

ok, Dave you mentioned in another thread to try :

Please Login or Register  to view this content.

place text in A1 and C1 and run the macro

However, this work with converting cells to uppercase, how would I convert this to convert vba textbox.text to uppercase. here is what I have tried,
that does not work:

Please Login or Register  to view this content.

The problem, is that all of these return "Cannot find project or library" error.

Is their a command that work in excel to do this ? I am using Excel 2003.

Thanks in advance,

oliver.

Hey,

Thank you, your absolutely correct. I worked on this document over the weekend at home, and from home I have a library for a phidgets controller that I play with, and it was attempting to find that library. Doh!. (beats head on desk).

so... I owe you a beer. If your ever near otawa, canada, give me a dingle..LOL!.

oliver.