+ Reply to Thread
Results 1 to 3 of 3

Worksheet focus always when using a userform

  1. #1
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    Worksheet focus always when using a userform

    I have a userform that loads when worksheets open and it is like the header or ribbon at the top of the spreadsheet. How do I setfocus to always be on the worksheets? I found this in a forum to set focus when userform initializes, (AppActivate Application.Caption), but as soon as I select something from the userform the focus is on it. I then have to click on the worksheet to get focus back. Is there anyway to always make the focus on the spreadsheet after selecting something on the userform? Do I need to add the (AppActivate Application.Caption) in every command on the userform? Thanks!

  2. #2
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    Re: Worksheet focus always when using a userform

    I found this on another forum and it works perfect, or good enough for my needs, other than with the DTPicker calander, "AppActivate ("Microsoft Excel")". I hope this forum does not mind me posting a link to the other forum.

    http://www.mrexcel.com/forum/excel-q...orm-excel.html

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Worksheet focus always when using a userform

    Hi thecdnmole

    Here's another Link that I've used...
    http://cpearson.com/excel/SetFocus.aspx
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ 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] Worksheet focus problem, how do I set focus?
    By MichiganWilliams in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2014, 03:04 PM
  2. Return focus to worksheet from userform Excel 2007 vs 2000
    By jaslake in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 07-06-2009, 11:17 PM
  3. [SOLVED] UserForm got focus
    By Henrich in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-13-2006, 11:30 AM
  4. [SOLVED] Userform Focus
    By David Coleman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2006, 01:55 AM
  5. Object on userform can't get focus
    By Jos Vens in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-28-2005, 08: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