Solved

Fix Highlighted and click on cell to search for specific column

Posted on 2016-10-05
16
42 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 46

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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 46

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 46

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 46

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 46

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 46

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 46

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 46

Expert Comment

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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

832 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