Breaking News: Grepper is joining You.com. Read the official announcement!

excel vba how to make shape visible while scrolling

Nutty Narwhal answered on April 25, 2022 Popularity 1/10 Helpfulness 1/10

answer excel vba how to make shape visible while scrolling

related excel vba how to make shape visible while scrolling

excel vba how to make shape visible while scrolling

Comment

Private eTime
Sub ScreenRefresh()
    With ThisWorkbook.Worksheets("Sheet1").Shapes(1)
        .Left = ThisWorkbook.Windows(1).VisibleRange(2, 2).Left
        .Top = ThisWorkbook.Windows(1).VisibleRange(2, 2).Top
    End With
End Sub

Sub StartTimedRefresh()
    Call ScreenRefresh
    eTime = Now + TimeValue("00:00:01")
    Application.OnTime eTime, "StartTimedRefresh"
End Sub

Sub StopTimer()
    Application.OnTime eTime, "StartTimedRefresh", , False
End Sub

Popularity 1/10 Helpfulness 1/10 Language vb

Source: stackoverflow.com

Tags: excel vba visible

Link to this answer
Share Copy Link

Contributed on Apr 25 2022

Nutty Narwhal

0 Answers Avg Quality 2/10

Closely Related Answers

excel vba how to make shape visible while scrolling

Comment

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    With ActiveSheet.Shapes(1)

        .Left = ActiveWindow.VisibleRange(2, 2).Left
        .Top = ActiveWindow.VisibleRange(2, 2).Top

    End With

End Sub

Popularity 3/10 Helpfulness 1/10 Language vb

Source: stackoverflow.com

Tags: excel visible vba

Link to this answer
Share Copy Link

Contributed on Apr 25 2022

Nutty Narwhal

0 Answers Avg Quality 2/10

excel vba how to make shape visible while scrolling

Comment

Private Sub Worksheet_Activate()
    Call StartTimedRefresh
End Sub

Private Sub Worksheet_Deactivate()
    Call StopTimer
End Sub

Popularity 2/10 Helpfulness 1/10 Language vb

Source: stackoverflow.com

Tags: visible excel vba

Link to this answer
Share Copy Link

Contributed on Apr 25 2022

Nutty Narwhal

0 Answers Avg Quality 2/10

excel vba how to make shape visible while scrolling

Contents

More Related Answers

excel vba how to make shape visible while scrolling

Closely Related Answers

excel vba how to make shape visible while scrolling

excel vba how to make shape visible while scrolling

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.