Results 1 to 2 of 2

Thread: Propertry Get / Form Usage
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jul 2009
    Posts
    1,570
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Propertry Get / Form Usage

    If I want a Form to 'remember' some values I can't unload it and then use Property Get? Correct?
    The right way woudl be to Hide the Form only.

    Then the Form Variables using Get will work 100%. This is no need to ever unload the Form?

  2. #2
    Board Regular Jeffrey Mahoney's Avatar
    Join Date
    May 2015
    Location
    Northwest Washington
    Posts
    1,523
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Propertry Get / Form Usage

    I have used that before. I don't why it wasn't reliable across workbooks

    I would just create a Public variable in a Standard module instead.
    Have you been frustrated searching the Mr Excel site using the internal search feature. Use Google instead:
    In your Search Bar, type: site:www.mrexcel.com/forum/ Search Words
    -------------------------------------------------------------------
    If I were in charge, I'd ask for opinions, and actually consider them!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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