It may be something along those lines, but it's for textboxes/comboboxes in a userform, so I don't think .Select works?
Essentially I think this could be done by creating lots of textboxes and toggling their visibility, but was hoping there was a little bit more of a built in feature than that. One that would show the little prompt message at the bottom of the cursor icon or something along those lines.
Ok so I probably explained this really poorly. Just found the solution and it's very simple. Am unsure what the code for it is. But all I had to do is add the text I wanted to the control tip text element in the properties window for textbox.