Consulting

Results 1 to 4 of 4

Thread: Userform instructions

  1. #1
    VBAX Regular
    Joined
    Nov 2018
    Location
    London, U.K.
    Posts
    99
    Location

    Userform instructions

    I am creating a userform in excel. I want to include "instructions" in the userform itself to guide users when filling in the form. Does anyone know how to do this, or point me to a resource that will explain?
    I cannot find anything when doing my own search.

  2. #2
    VBAX Expert Logit's Avatar
    Joined
    Sep 2016
    Posts
    613
    Location
    .
    If the instructions are lengthy I would consider using a second user form to be opened with the instructions embedded therein.

    If the instructions are short, I would consider using a MsgBox with the instructions. Maybe click on the label for each control would
    activate the MsgBox ?

  3. #3
    VBAX Regular
    Joined
    Nov 2018
    Location
    London, U.K.
    Posts
    99
    Location
    Quote Originally Posted by Logit View Post
    .
    If the instructions are lengthy I would consider using a second user form to be opened with the instructions embedded therein.

    If the instructions are short, I would consider using a MsgBox with the instructions. Maybe click on the label for each control would
    activate the MsgBox ?
    Thank you for this. I had not considered a message box before, but I think that would be a good solution for me.

  4. #4
    VBAX Mentor
    Joined
    Apr 2009
    Location
    Kingsbury
    Posts
    423
    Location
    You can also use control tip text in properties for each input box
    just another way, the text will appear when you hover over with the mouse
    Last edited by Rob342; 11-30-2018 at 08:31 AM. Reason: added text

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •