When double click and moving to a new page have it automatically reset so that it won't display value.

Good Morning Expert Exchange community, helpers and users.

---Want to see if someone can help me get this function that when i am in the main page and click on any Main Task for exp (COLLEGE)
     Have it automatically refresh, so that when moving to the (COLLEGE) page i don't see "VALUE" on the "J" column

---What i want to see on the "J" column is that when double click have it REFRESH the "J" column automatically.

when-clicking-on-Main-Task-have-the-.png
 After-when-clicking-on-Main-Task-hav.png
After-when-clicking-on-Main-Task-hav.pngAfter-when-clicking-on-Main-Task-hav.png
28978771.xlsm
Omar HernandezAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Martin LissConnect With a Mentor Older than dirtCommented:
Replace you Worksheet_BeforeDoubleClick event with this
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

Dim dccolumn As Integer
Dim dcvalue As String

dccolumn = ActiveCell.Column
dcvalue = ActiveCell.Value


If Application.Intersect(ActiveCell, [Headers]) Is Nothing Then

       Range("C2").Value = Target.Value
        Cancel = True
        
       If ActiveCell.Value <> "" Then
        
        ActiveSheet.ShowAllData
        
        ActiveSheet.ListObjects("Table134").Range.AutoFilter field:=5, Criteria1:=Selection.Text, Operator:=xlOr, Criteria2:="DIVIDER"
        '******* 28979574 Start *******
        refresh
        '******* 28979574 End *********
        
        Application.EnableEvents = True
        
        End If
    
    End If
    
End Sub

Open in new window

0
 
Martin LissOlder than dirtCommented:
No matter what row I select, when I click on the red arrow I always get this.
????And nothing unusual happens if I click on a row when it's in that state.
0
 
Omar HernandezAuthor Commented:
after you click the down arrow

click then on college
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Martin LissOlder than dirtCommented:
After clicking on College.
After clicking on College.
0
 
Martin LissOlder than dirtCommented:
BTW, I've asked this before, but when the sheet is collapsed as above, how do you get back to showing all the rows?
0
 
Omar HernandezAuthor Commented:
I meant to say, Double click on the cell that say "COLLEGE" (Double Click)
0
 
Omar HernandezAuthor Commented:
In response to,

BTW, I've asked this before, but when the sheet is collapsed as above, how do you get back to showing all the rows?

i have it to be the object that looks likes the sun next to the down arrow, the file that you have is not updated, but i recorded macro call all
--on row 4, i click on cell with table, (shift,ctrl and L double time) and assign it to the object that looks like the sun.
0
 
Omar HernandezAuthor Commented:
Hey Marty when i make the changes, it works but it always brings me to the bottom of the sheet.

---May you let me know what to do so that when it finish doing what it should to always end up on the top of the page.
0
 
Martin LissOlder than dirtCommented:
Add this right after line 21.

        ActiveWindow.ScrollRow = 1
0
 
Omar HernandezAuthor Commented:
Thanks Marty, this new feature works great, love it...
0
 
Martin LissOlder than dirtCommented:
Currently if you click a row below the table like row 110, it turns yellow. I assume that that's OK, but if you then select any other row, range K:N for row 110 remains yellow. To fix that go to the Worksheet_SelectionChange event and change this

Range("a1:J" & "5000").Interior.ColorIndex = xlNone

to

Range("a1:" & strLastCol & "5000").Interior.ColorIndex = xlNone
0
 
Omar HernandezAuthor Commented:
Thanks for your additional input, fix and better... thanks again Marty
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.