+ Reply to Thread
Results 1 to 3 of 3

Copying InkPicture Content from Userform to Worksheet Control of different dimensions

  1. #1
    Registered User
    Join Date
    04-17-2020
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    2

    Question Copying InkPicture Content from Userform to Worksheet Control of different dimensions

    Hello,

    I have been searching for a few days now but with no concrete answer found. I have a InkPicture in a Userform of which the user places his signature and it gets transferred to the worksheet. Thanks to other threads, I was able to move the content from the userform to the sheet; however, due to the limited space on the sheet (to fit one page), I had to to keep the userform inkpicture size the same as the one in the sheet or else it will be cropped. I want to enlarge the inkpicture control size in the userform to make it easy for the user to sign while keeping the one in the sheet a smaller size to fit the A4 format. Is there any code that will allow for that.

    Picture in attachment for reference.

    Thank you in advance and appreciate your support.

    Regards
    Attached Images Attached Images
    Last edited by HHajouj; 04-19-2020 at 01:06 PM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,613

    Re: Copying InkPicture Content from Userform to Worksheet Control of different dimensions

    Add an ActiveX Image control to your worksheet. Size and position it where you like.

    This will save the Ink as an image and load it in the Worksheet image control which is set to Zoom the image to fit.

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    04-17-2020
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    2

    Re: Copying InkPicture Content from Userform to Worksheet Control of different dimensions

    Thank you so much!!! Works perfectly.

+ 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. Image saved from inkpicture userform changing size
    By Jissenka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2017, 07:07 PM
  2. [SOLVED] Show UserForm InkPicture in Sheet
    By nickwoowoo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-26-2017, 02:28 AM
  3. Show UserForm InkPicture in Excel Sheet
    By RaphaelCodak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-25-2017, 07:30 PM
  4. Populating Userform ComboBox Using Items from Content Control Combobox
    By anarxo in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2014, 01:00 PM
  5. Worksheet Control in Userform
    By herghost in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2012, 01:51 PM
  6. Excel 2007 : Control Button Not Copying With Worksheet
    By GeoffS4 in forum Excel General
    Replies: 0
    Last Post: 02-28-2011, 11:46 AM
  7. [SOLVED] Copying content and formats to another worksheet
    By Zach Mathew in forum Excel General
    Replies: 1
    Last Post: 04-11-2005, 08:06 PM

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