Run-time error '438': Object doesn't support this property or method

I can't work out why I'm gettinbg the 438 error when I use the following piece of code.
It should check to see if some check boxes are clicked, and if text is entered, and if not, returns an error message, but whenever I check the box I get a 438 Run-time error : Object doesn't support this property or method
any help - appreciated :D

Please Login or Register  to view this content.

It breaks on the
If ActiveWorkbook.Sheets("CallCredit").txtCallCredit.Text = "" Then
Line.

am I misssing a reference or something?
so confused!

Hello Ophelia,

Here's how to check a Control Toolbox TextBox's value. It isn't straight forward like a Form Toolbar control.

Please Login or Register  to view this content.

Added to your Macro:

Please Login or Register  to view this content.

Sincerely,
Leith Ross

hi, sorry it's taken a few days before I could reply, I've tried out your code and whilst I appreciate what you've done, I'm still having problems, basically, I'm checking to see if one of 3 check boxes has been ticked, and if not it displays the message "You have not selected any new, change or deletion to any signon?" in a text box.
It currently works for other check box groups on this sheet but not for this new one, I've tried your module but when I select a check box it still displays that message.
The code is rather long and it's a big spreadsheet, which I can email to you if needs be?
anyhelp would be appreciated.
Thanks!