+ Reply to Thread
Results 1 to 2 of 2

how can i give a link to one user form to anther user form

  1. #1
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    how can i give a link to one user form to anther user form

    i have create two userforms

    in one uerform i have used an logout button

    in another i have used an two labels

    lbl1-->logout date and time is

    lb2--->display here(date and Time)

    and it should saved in my sheet location(sheet2)
    |
    link(\\bms\Service log request\login details\workstation.xlsx)


    how can i do this

    please help me

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: how can i give a link to one user form to anther user form

    Simple solution is to set some global variables in your main Macro Module
    public Label1, Label2 as string

    Then in your First userform Terminate event, initialise the second Userform

    In the second Userform initialise event read the two global variables.

    Then in your Second userform Terminate event write the date and time.

    I have tested this for you and basically it works. I had to hide Userform1 before showing userform2
    and then unload userform1 in the terminate event for userform2

    I went a bit further and created a textbox on userform1 to show the time.
    I had to use ontime for this. and Quit to stop the timer.
    Attached Files Attached Files
    Last edited by mehmetcik; 08-30-2014 at 08:43 PM.

+ 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] User Form - Hyperlink Button within a Form, to create a Link on a Designated Cell
    By Sinalk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2013, 07:29 AM
  2. [SOLVED] User Form to execute search and return all values to the user form for editing
    By allwrighty in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-11-2013, 10:40 PM
  3. [SOLVED] Excel vba user form- open directly to user form not worksheet
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 04-24-2013, 05:07 PM
  4. [SOLVED] Excel user form- If/Then statement outcome to show on user form
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2013, 09:16 AM
  5. Print preview from user form opened from a user form
    By Brunstgnegg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2011, 05:12 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