Hi Ossie,

Yes, I use code to update the text boxes. It would be nice to have the
checkboxes respond to the textbox changes in the userform


Dave Peterson below has a nice solution for me that does update

Many thanks,

Roger


"OssieMac" wrote:

Hi Roger,

"The textboxes are populated from a sheet with various items." Does this
mean they are populated with code?

Do you want the checkboxes updated as each textbox is updated or can they be
done in bulk like after a particular textbox is updated or with a button etc?


--
Regards,

OssieMac


"Roger on Excel" wrote:

I have a userform with a column of text boxes (TextBox1, 2, 3...10) and
adjacent Check boxes (CheckBox1, 2, 3...10).

The textboxes are populated from a sheet with various items.

What I need is for the adjacent Check boxes to be checked if the textboxes
contain either the text AAAAA or BBBBB and unchecked for anything else.

Can anyone help?

Many thanks,

Roger