Conditional formatting not applying when sending data from userform to column

[AndyEd]

I have a column used to display dates. It is conditionally formatted to highlight those falling within the current week, next week, etc.

It seems that when I send a data to the column via a userform, it is not applying the formatting. Is that the case, and if so, is there a workaround?

Thank you.

 

[dmt32]

Hi,
what comes out of textbox or combobox is text.. Try using one of the Type conversion functions to coerce your string date & see if this resolves the issue.

example

Range("A1").Value = CDate(Me.TextBox1.Value)

You can read more about type-conversion-functions in VBA helpfile.

Dave