Consulting

Results 1 to 4 of 4

Thread: link a user interface to another user interface

  1. #1

    Arrow link a userform to another userform via a button

    Hi!
    how can i link a userform to another using VBA? What code do i need to use? - using a MS Excel 2003.

    What i want is to be able to click on button on the main userform that links and displays another userform.

    Thanks
    Last edited by HM4; 12-05-2007 at 09:30 AM.

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    I think you might have to explain yourself soemwhat. I for one have no ide by what you by a user interface.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Tutor
    Joined
    Oct 2007
    Posts
    210
    Location
    sub button1_click()
    formname.show
    end sub

    I am assuming that the button is named button1
    insert the name of the form for formname

    This should work

  4. #4
    THANK U THANK U THANK U THANK U THANK U THANK U THANK U THANK U THANK U THANK U THANK U THANK U THANK U THANK U

Posting Permissions

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