Consulting

Page 3 of 3 FirstFirst 1 2 3
Results 41 to 53 of 53

Thread: Selecting a team from a ListBox

  1. #41
    Microsoft Word MVP 2003-2009 VBAX Guru gmaxey's Avatar
    Joined
    Sep 2005
    Posts
    3,334
    Location
    Nobody wants to rebuild your form. Send the document to me and I'll post it here.
    Greg

    Visit my website: http://gregmaxey.com

  2. #42
    VBAX Mentor
    Joined
    Aug 2020
    Location
    Hampshire
    Posts
    395
    Location
    Erm, I have no way of attaching my document.

    The security issue was nothing to do with trying to upload it, rather that the information on it is sensitive. I've removed the sensitive stuff and am more than happy to share the form. Just need to know how. According to the posting permissions I am allowed to do this, I just can't see how.

  3. #43
    Microsoft Word MVP 2003-2009 VBAX Guru gmaxey's Avatar
    Joined
    Sep 2005
    Posts
    3,334
    Location
    Click on the Go Advanced button and upload the file.
    Greg

    Visit my website: http://gregmaxey.com

  4. #44
    VBAX Mentor
    Joined
    Aug 2020
    Location
    Hampshire
    Posts
    395
    Location
    Yeah, I have the advanced option okay, but when I try to upload the document it states that it is an invalid file type. This is annoying as it clearly states that a .dotm file is permitted.

  5. #45
    Microsoft Word MVP 2003-2009 VBAX Guru gmaxey's Avatar
    Joined
    Sep 2005
    Posts
    3,334
    Location
    Try saving it as a docm and try again or send it to me and I'll post it.
    Greg

    Visit my website: http://gregmaxey.com

  6. #46
    VBAX Mentor
    Joined
    Aug 2020
    Location
    Hampshire
    Posts
    395
    Location
    Here is my form. Hope that this helps others too!Attachment 27280
    Attached Files Attached Files
    Last edited by HTSCF Fareha; 10-07-2020 at 10:51 AM.

  7. #47
    Microsoft Word MVP 2003-2009 VBAX Guru gmaxey's Avatar
    Joined
    Sep 2005
    Posts
    3,334
    Location
    I don't know what you attached, but it isn't a file with a userform and code. Why don't you just send me the file by contacting me via my weblink.
    Greg

    Visit my website: http://gregmaxey.com

  8. #48
    VBAX Mentor
    Joined
    Aug 2020
    Location
    Hampshire
    Posts
    395
    Location
    Sorted!

  9. #49
    Microsoft Word MVP 2003-2009 VBAX Guru gmaxey's Avatar
    Joined
    Sep 2005
    Posts
    3,334
    Location
    I don't know what you think you sorted, but if I download that attached file and attempt to open it nothing happens. Word simply opens with a new blank document. No file name, no code, no userform.
    Greg

    Visit my website: http://gregmaxey.com

  10. #50
    VBAX Mentor
    Joined
    Aug 2020
    Location
    Hampshire
    Posts
    395
    Location
    Does it make a difference if the file extension is changed back to .dotm

  11. #51
    Microsoft Word MVP 2003-2009 VBAX Guru gmaxey's Avatar
    Joined
    Sep 2005
    Posts
    3,334
    Location
    No. Last time. Send me the file and I will post it or just forget about it.
    Greg

    Visit my website: http://gregmaxey.com

  12. #52
    VBAX Mentor
    Joined
    Aug 2020
    Location
    Hampshire
    Posts
    395
    Location
    Sent it as an attachment to your private email.

  13. #53
    Microsoft Word MVP 2003-2009 VBAX Guru gmaxey's Avatar
    Joined
    Sep 2005
    Posts
    3,334
    Location
    Steve (the OP) and I have collaborated offline a bit on the development of his form. The end result is attached:

    TriageShifts.docm
    Greg

    Visit my website: http://gregmaxey.com

Posting Permissions

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