Solved

Fix Highlighted and click on cell to search for specific column

Posted on 2016-10-05
16
31 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
  • 8
  • 8
16 Comments
 
LVL 45

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
 
LVL 45

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 45

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 45

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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

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 45

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 45

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 45

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 45

Expert Comment

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

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

760 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now