+ Reply to Thread
Results 1 to 3 of 3

Show UserForm when switch to a sheet Solved by : ?

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,011

    Thumbs up Show UserForm when switch to a sheet Solved by : ?

    hello evryone

    i want to show my userform("UserForm1") when i goto sheets("sheet1")

    when i select this form property of userform ,...... showmodel = false

    i want here userform don't show on other sheets

    e.g i want to popup userform on sheet1 and showmodel = false

    then userform show only on sheet1 if i go to sheet2 then userform = hide


    thanx a lot
    Last edited by HaroonSid; 03-29-2014 at 06:40 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,167

    Re: Show UserForm when switch to a sheet

    Put code in Thisworkbook object.
    It uses code name of Sheet1 rather than sheet tab name, but you can change that.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,011

    Re: Show UserForm when switch to a sheet

    Hello Andy Pope

    thanx a lot for quick reply but

    i want this and found it

    Please Login or Register  to view this content.

+ 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] Show UserForm InkPicture in Sheet
    By nickwoowoo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-26-2017, 02:28 AM
  2. [SOLVED] Show results from a sheet in a userform
    By MariaPap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2014, 12:25 PM
  3. How to Show record from Sheet2 not Sheet 1 in the UserForm ListBox1.
    By z-eighty2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2013, 05:39 PM
  4. [SOLVED] VBA Help - List show in userform's combo box from sheet
    By sa.1985 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2012, 08:33 AM
  5. UserForm to search sheet, show results on separate userform?
    By egemenkepekci in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2010, 01:06 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