I have a form that's been set up in Excel, and need to check some of the fields have been filled in prior to printing or saving, and if they are empty then n error message is generated. The numeric fields are fine and work ok, but the text fields don't want to play. I'm using
If Selection.FormulaR1C1 = "" then msgbox("...") etc
I'm sure there's a proper way but can't see it. Please can anyone help?
Thanks
If Selection.FormulaR1C1 = "" then msgbox("...") etc
I'm sure there's a proper way but can't see it. Please can anyone help?
Thanks