Results 1 to 12 of 12

Using UserForm to set PageSetup properties

Threaded View

  1. #8
    Registered User
    Join Date
    11-28-2012
    Location
    NA
    MS-Off Ver
    Excel 2013
    Posts
    34

    Re: Using UserForm to set PageSetup properties

    I have updated the worksheet for page orientation and print grid line. I took a swing at the dates issue, but I don't think I have it quite right. I'm not very good at the user validation part. Is there a reference guide on that for common validation coding?

    I went ahead and attempted to place the form into a Tab in Excel after figuring out how to "Save" data to a worksheet using ControlSource. The issue I came across is that the worksheet doesn't seem to appear when in XLAM form. Is there a better way? It works perfectly in a normal worksheet, but the end goal is to place several macros into a tab for multiple people to use as shortcuts.
    Attached Files Attached Files
    Last edited by suiathon; 08-22-2020 at 12:23 AM. Reason: Added text

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. PageSetup properties using variables
    By froodo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-08-2009, 08:25 PM
  2. Properties not staying with UserForm
    By SQChevy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-04-2008, 09:46 AM
  3. Userform properties
    By JohnSeito in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2008, 10:47 PM
  4. Assigning userform properties to an array
    By Cumberland in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2006, 07:40 AM
  5. Change properties of a userform
    By Mike Archer in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-06-2006, 08:40 PM
  6. Properties of Combo Box in Userform
    By Chris Gorham in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-06-2006, 04:50 PM
  7. Setting PageSetup Properties in Multiple Worksheets
    By Josh Sale in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-28-2006, 02:25 PM
  8. Q: copying PageSetup properties from one worksheet to another
    By A C in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2005, 11: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