Solved

Fix Highlighted and click on cell to search for specific column

Posted on 2016-10-05
16
49 Views
Last Modified: 2016-10-05
Wanted to have this function fix where where ever i click

***I will have a yellow highlight row

and when double click

***Search for a specific column on the file

Please refer to specified detail on this video clip

you can see the glitch i am having on this link
https://www.youtube.com/watch?v=uR37EqXmUrA&feature=youtu.be

Or

Go to YouTube and on search bar copy and paste the following
Problem with clicking, highlight and search column disabled

Open in new window

28973745c.xlsm
0
Comment
Question by:Omar Hernandez
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 8
16 Comments
 
LVL 47

Expert Comment

by:Martin Liss
ID: 41830741
When you double-click a cell is it supposed to collapse everything? If so then try this workbook. BTW, other than manually unhiding the hidden rows, is there some way to unhide them after the double-click?
28974603.xlsm
0
 

Author Comment

by:Omar Hernandez
ID: 41830758
If i am not mistaken i believe that when i Double click on a cell it will search for that specific word on the "E" column only.
0
 

Author Comment

by:Omar Hernandez
ID: 41830771
tried the following file, did not work friend
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 47

Expert Comment

by:Martin Liss
ID: 41830857
I think the highlighting worked but the double-click didn't. In any case try this version.
28974603a.xlsm
0
 

Author Comment

by:Omar Hernandez
ID: 41830878
No highlight or double click functioning in my end.
0
 
LVL 47

Expert Comment

by:Martin Liss
ID: 41830893
Well it works for me (testing in the first few rows under ToDo) so there are only two things I can think of.

1) Most likely Appliaction.EnableEvents is False from the last time you used the workbook, so got to Visual Basic, type Ctrl+G, and in the Immediate window type Appliaction.EnableEvents = True and press Return. Go back to Excel and try it again.

2) If that doesn't work then maybe you're not looking at the 28974603a.xlsm workbook.
0
 

Author Comment

by:Omar Hernandez
ID: 41830902
have you checked the video Martin liss it works if you stay on the same part of the file if you start clicking it will disable it please see the video, so that you may see what i am coming from friend.
0
 
LVL 47

Expert Comment

by:Martin Liss
ID: 41830908
Here's what I did just now and the results.

Click cell C6 - > highlights
Click cell D16 - > highlights
Click cell E23 - > highlights
Click cell J34 - > highlights
Click cell E41 - > highlights

Some columns don't highlight like "A" and "H"
0
 

Author Comment

by:Omar Hernandez
ID: 41830946
yes the work it works is that if there is no nothing on a cell it will not highlight, for anything else, highlight function will work.
0
 
LVL 47

Expert Comment

by:Martin Liss
ID: 41830957
OK I changed the Worksheet_Change event to highlight even when an empty cell is clicked.
28974603b.xlsm
0
 

Author Comment

by:Omar Hernandez
ID: 41831031
I have noticed that this worked please check out the video and hopefully you may see a better way to approach it.

***Have it in a way, so that when i click on the refresh button have this in order
-------- Activate right (After having date with Q's updated on the "J" Column) code to refresh/reset or activate those two option Hightlights ROW when clicked once and also when double click have it search for the same word clicked on the "E" Column.

Hopefully this video will work or give you an idea what will be a great way to approach this function.

On YouTube page, on search bar copy and paste the following.
Double click ideas in having it fix

or

Click on this link to be redirected on the YouTube Page
https://www.youtube.com/watch?v=ZcQhYkROs1k&feature=youtu.be
0
 
LVL 47

Expert Comment

by:Martin Liss
ID: 41831054
I'm sorry.  I watched the video but I don't understand what you need. In any case is seems like I've fixed this problem so please close this question and ask a new one. When you do please describe in words, step by step

what you do
what happens when you do it
what you want to have happen instead.
0
 

Author Comment

by:Omar Hernandez
ID: 41831059
Hey martin liss

the title of this question is

Fix Highlighted and click on cell to search for specific column

it is still not fixed if you see the first file that we have started to work i can move and click on buttons customized and still it won't disable those two condition

***Click on cell and if with letter/word on cell highlight row
***Double click to search for the word on the cell click, on the "E" column

both of this function work Martin liss

---but as i said if you click on the DOWN ARROW ORANGE icon located on the left side of the top page it for some reason disable those two condition mentioned above if these condition works when i click on the DOWN ARROW ORANGE Icon located on the left side of the top page this question will be completed.

I just want these two condition to work when i click on the DOWN ARROW ORANGE icon located on the left side of the top page.

Hope this is clear friend.
0
 
LVL 47

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 41831066
Replace the "Folders" macro in Module9 with this. Line 13 is new.
Sub Folders()
'
' Folders Macro
'

'
    Range("Table134[[#Headers],[TASK]]").Select
    Selection.AutoFilter
    Selection.AutoFilter
    ActiveSheet.ListObjects("Table134").Range.AutoFilter field:=5, Criteria1:= _
        "FOLDER"
        
    Application.EnableEvents = True
End Sub

Open in new window

0
 

Author Closing Comment

by:Omar Hernandez
ID: 41831071
MARTIN LISS, MARTIN LISS YOU ARE THE MEN! with all do respect friend thanks a mil you did the impossible, again thanks a mil.
0
 
LVL 47

Expert Comment

by:Martin Liss
ID: 41831072
Again, glad I was able to help.
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
I NEED KEEP THE CONDITIONAL  FORMATTING 24 28
Excel Macro - loop 4 11
ms/link form - subform field not recognised 3 16
Need adjust data counting 17 15
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question