Userform to trigger once a certain has been met in columns A to F

[danbates]

Hi,

Please could someone help me?

I would like a VBA code that doesn't allow the userform in column G to trigger until certain values have been met in columns A to F. Also if one hasn't been met then I would like a message box to state which column hasn't been met please.

Column A = min of 8 characters
Column B = min of 6 characters
Column C = just needs a value
Column D = just needs a value
Column E = just needs a value
Column F= just needs a value

I hope this make sense.

Thanks

Dan