+ Reply to Thread
Results 1 to 2 of 2

Information about create a global variable

  1. #1
    Registered User
    Join Date
    12-04-2016
    Location
    tech
    MS-Off Ver
    2016
    Posts
    21

    Information about create a global variable

    Dear all member!

    no code as of yet

    scenario

    I have one active x textbox in which a macro is run based on that value
    however, everytime the macro is ran, the textbox value disappears
    I tried setting the value in the textbox1 properties section by typing the value of 10
    but that does not work.
    I would like the value to stay fixed within that textbox even after a macro is ran
    so I heard you have to assign a textbox value to a variable
    I'm not quite sure of the setup, but a brief sample of how to create a global variable
    where that value of 10 is always in the textbox so that it does not disappear.

    Thanks as always.
    Ads: chúng tôi là diểm đến lư tường cho dịch vụ internet fpt an gianginternet fpt bạc liêu
    internet fpt bến tre cho quư khách.
    Last edited by thanhvanchi; 12-16-2016 at 03:51 AM.
    Ch?c c?c bạn vui vẻ.

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Information about create a global variable

    everytime the macro is ran, the textbox value disappears
    Then the code is clearing the textbox - just a guess, absence of the code means that's all anyone can say...

+ 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] Global variable declared in Userform. Variable value is not sticking
    By timtim89 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-25-2012, 08:50 AM
  2. Replies: 3
    Last Post: 05-08-2012, 05:09 PM
  3. How to Create a Macro to Edit a Variable Amount of Information
    By Matt in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-12-2006, 05:10 PM
  4. Replies: 3
    Last Post: 09-06-2005, 07:05 AM
  5. Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  6. Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. Replies: 1
    Last Post: 07-08-2005, 09:05 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