I'm opening my UserForm1 by selecting a specific cell (any cell within a range of A2:A100). I say "specific cell" because UserForm1 is pulling info back into my TextBox1 and TextBox2.
However, if any cell within my range of A2:A100 is empty, I want UserForm1 to open with a grey instruction text...