All three basic order types -- market orders, limit orders, stop orders -- can be used to either enter or exit a position. You can also use any one of them with either long or short positions, if the instrument you're trading is shortable.

So yes, you can use a stop limit to enter long, so that the limit order that gets submitted to the exchange once the stop is triggered prevents a bad fill price.