It's strongly implied that Holmes used morphine for recreation as well by the fact that Watson had to ask which habit he was indulging in The Sign of the Four.

"Which is it today," I asked, "morphine or cocaine?" "It Is cocaine," he said, "a seven-percent solution. Would you care to try it?..."