hi im loking for a macro which will unhide a range of cells if it contains text

e.g. A1-A10 rows have been hidden if I put text in it via userfrom I want the row to unhide and become visible