Results 1 to 6 of 6

Thread: want keep the value of a variant from one form to another

Hybrid View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jun 2003
    Location
    france
    Posts
    71

    Resolved want keep the value of a variant from one form to another

    got a small application with many form creating a workbook, and i got often from workbook with data to new workbook, lets nama this variant wbname.

    I tried to declare it as a static but when i star a new form the is still nothing how come, maybe i declare it in the wrong place (the first form module)

    hope some knows
    Last edited by writelearner; Sep 22nd, 2004 at 09:51 AM.

  2. #2
    Fanatic Member Bombdrop's Avatar
    Join Date
    Apr 2001
    Location
    St Helens, England, UK
    Posts
    667
    Best way to achive this is to declare your variable as public in and Bas module.


    eg.

    VB Code:
    1. Public wbname as variant

    Hope this helps


  3. #3

    Thread Starter
    Lively Member
    Join Date
    Jun 2003
    Location
    france
    Posts
    71

    Smile

    thanks a lot and sorry for the mistaping

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Jun 2003
    Location
    france
    Posts
    71

    solved

    do i have to say that the treat is solved

  5. #5

    Thread Starter
    Lively Member
    Join Date
    Jun 2003
    Location
    france
    Posts
    71

    want keep the value of a variant from one form to another resolved

    it look like it is resolved i have to say

  6. #6
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343
    if you want resolved in the original post title, open the thread, on the first post click edit then add *resolved* or (Resolved) to the end of the title (or the begining) then click save.

    Vince

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

Posting Permissions

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



Click Here to Expand Forum to Full Width