+ Reply to Thread
Results 1 to 2 of 2

Print button in userform's title bar

  1. #1
    Registered User
    Join Date
    06-18-2013
    Location
    Delhi, India
    MS-Off Ver
    Excel 2010
    Posts
    35

    Smile Print button in userform's title bar

    Hi Friends,

    I have created a tool by using few userforms in it. Now my boss is asking me to place a print button in the title bar next to the close button.

    So I wanted to know that is it possible to place a print button (in the title bar) next to close button in activeX userform?
    If yes, then can you please tell me how?

    Thanks all

  2. #2
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Print button in userform's title bar

    I think you can "do" it if your boss insists:
    -remove the title bar of your userform
    -add a frame where the title bar should be
    -add on it a commandbutton (nice colored with a red X for "close")
    -add another button for print... now your userform has the close X and the print button.

    hope it helps you!
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

+ 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. [SOLVED] EXCEL USERFORM- Unable to print spreadsheet using command button
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-19-2013, 10:26 AM
  2. Print Button to print UserForm for multi-sheet
    By smartcard in forum Excel General
    Replies: 12
    Last Post: 04-29-2010, 07:47 AM
  3. Print button to print userform
    By jcarstens in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-20-2009, 08:18 PM
  4. Print a PDF document from Userform Command Button
    By msommerf in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-20-2009, 12:38 PM
  5. Print Title
    By Schlic in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-22-2008, 02:28 AM

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