+ Reply to Thread
Results 1 to 4 of 4

Using InkPicture to input a signature on a worksheet - Type Mismatch Error

  1. #1
    Registered User
    Join Date
    07-09-2021
    Location
    United Kingdom
    MS-Off Ver
    10
    Posts
    13

    Using InkPicture to input a signature on a worksheet - Type Mismatch Error

    Hi all,

    Wondering if you could help me with an issue im having.

    I have a userform that when you click the command button, it brings up another userform with an InkPicture box. The user then presses the 'Accept Signature' button. The signature is saved in a temporary place and then placed in the original userform and a temporary worksheet which is basically a replication of the original userform so that i can save it to PDF.

    Please Login or Register  to view this content.
    I'm managing to get the signature to be saved in the location, but i keep getting the 'Type Mismatch' error when it coms to putting the files in the userform.

    Any help would be much appreciated.
    Last edited by BettyMay; 10-07-2021 at 06:24 AM.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,263

    Re: Using InkPicture to input a signature on a worksheet - Type Mismatch Error

    The Picture property requires an actual image, not the path to one, so you need to pass the path to LoadPicture
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,743

    Re: Using InkPicture to input a signature on a worksheet - Type Mismatch Error

    Try:

    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  4. #4
    Registered User
    Join Date
    07-09-2021
    Location
    United Kingdom
    MS-Off Ver
    10
    Posts
    13

    Re: Using InkPicture to input a signature on a worksheet - Type Mismatch Error

    You are a legend. Thank you so much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. InkPicture line type changes after select
    By MeBob in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2020, 10:45 AM
  2. [SOLVED] Textbox input value - type mismatch
    By jazbath in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-10-2016, 10:24 PM
  3. Worksheet Reference Returns Type Mismatch Error when Using Network Drive
    By ShitLeopard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2015, 04:14 PM
  4. [SOLVED] 'Type mismatch error' while translating the worksheet function to VBA
    By ramananhrm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-30-2013, 03:02 AM
  5. Type mismatch using rnge as Range with Type 8 Input Box
    By STEVE BELL in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-03-2005, 01:10 AM
  6. input box date type mismatch
    By Matilda in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-26-2005, 10:45 AM
  7. [SOLVED] Help: Compile error: type mismatch: array or user defined type expected
    By lvcha.gouqizi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2005, 05:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1