Combining with a steroid hormone and transmitting the signal within the cell to initiate a change in cell activity or function.