Update data

Hi all,

I wrote an userform to insert data.
Sometimes, it is necessary to add some data later.

One solution may be that as soon as the userform opens, the background color of the combo or text boxes "in the opened userform " changes. This way I know which are the missing records

Is there any command in VBA that allow me to change the color of a box when the userform is open?
Something like..
if (the activecell) = "" then
change the backround color of the related combobox"

end if

thank you
Anna

Maybe something like this ?

Please Login or Register  to view this content.

Thank you!!
It works !!

You're welcome.
Glad that I can help .

Hi,
with the PC it works, but not with the mac.

do you know why?

thank you
Anna