+ Reply to Thread
Results 1 to 3 of 3

Sheet activation after or before next RefEdit is to be used

  1. #1
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,138

    Sheet activation after or before next RefEdit is to be used

    Hi Guys

    Here's a challenge ...
    All searches warned me about RefEdit controls but somehow I managed to workaround the issues...so completed 15 userforms making use of them...Now all of a sudden I need to make use of 2 Refedits in my last userforms and am struggling to find a workaround for sheet activation...

    Scenario in attached workbook as follows ... Form opens on sheet2 user selects range1 on Sheet1 via RefEdit1 ...
    Now user clicks RefEdit2 ... automatically sheet2 is again the active sheet ...

    How can I get Sheet1 which is RefEdit1 parent as the active sheet... I really don't want to have to incorporate a textbox workaround ...
    In a previous thread I made use of the next in line command button to solve for 1 RefEdit ...What now?
    Attached Files Attached Files
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,138

    Re: Sheet activation after or before next RefEdit is to be used

    Hey guys...Herewith RefEdit alternative which solves my problem....Still can't believe that there is no workaround for RefEdit control
    Attached Files Attached Files

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,138

    Re: Sheet activation after or before next RefEdit is to be used

    I cannot believe that something this simple ...solved my post 1 ...

    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] Set focus to selected sheet when userform is open and using making use of RefEdit
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-07-2018, 12:17 AM
  2. REfedit Help
    By viruzman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-09-2012, 01:02 PM
  3. refedit help
    By jlt199 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2012, 03:59 PM
  4. Using RefEdit
    By ben_sumner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2007, 05:21 AM
  5. RefEdit ???
    By T.c.Goosen1977 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2006, 10:11 AM
  6. RefEdit ???
    By T.c.Goosen1977 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2006, 10:06 AM
  7. RefEdit
    By TJ@abc.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-12-2006, 09:15 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