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?
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 General Rules if you want my help. Not aimed at any person in particular:
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks