+ Reply to Thread
Results 1 to 3 of 3

How to refresh change without click cell?

  1. #1
    Forum Contributor
    Join Date
    03-04-2015
    Location
    Jakarta
    MS-Off Ver
    15
    Posts
    154

    Post How to refresh change without click cell?

    I hide rows with value change on another cell automatically (Private Sub Worksheet_SelectionChange(ByVal Target As Range), but it wouldn't change if I don't have click one cell or press Enter button. How to apply change without click one cell or press Enter button?

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

    Re: How to refresh change without click cell?

    You cannot.

    Excel does not process the change event until you leave the cell.

    What you are asking for is a keydown event, these do not exist in the worksheet.

    Instead insert an Activex textbox. The following will hide row 5 if you press 1 in the textbox and unhide it if you press any other key.
    Modify it to meet your requirement.

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 03-20-2016 at 04:28 AM.
    My Rules if you want my help:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Contributor
    Join Date
    03-04-2015
    Location
    Jakarta
    MS-Off Ver
    15
    Posts
    154

    Re: How to refresh change without click cell?

    Yes, you are right. It can't be done.
    Thanks for codes. But, I am not using textbox now. On next time I can use your codes.
    And thanks for your advices.

+ 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. Refresh all pivot tables upon change of data in a single cell
    By KAC1979 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-12-2013, 02:21 PM
  2. [SOLVED] click on image change value in cell
    By arctushar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-16-2013, 01:52 PM
  3. change value of cell by a click - 1 or 0
    By techexpressinc3 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-20-2013, 07:18 PM
  4. [SOLVED] Using VBA to change a pivot table filter, refresh the report and set up a refresh delay
    By Bonnister in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-18-2012, 10:43 AM
  5. Excel 2007 : Change color of cell on click
    By TToc2u in forum Excel General
    Replies: 0
    Last Post: 12-08-2011, 07:04 PM
  6. Refresh pivot tables on cell change
    By cmb80 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2011, 07:04 AM
  7. Page Field and Refresh based on Cell change
    By kmlloyd in forum Excel General
    Replies: 0
    Last Post: 07-14-2010, 01:48 PM
  8. SQL - Auto Refresh Upon Cell Value Change
    By Elliot J in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-12-2005, 06:06 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