Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem running code in proper order
My problem is that the code:
Call FindLastNoXXX.FindLastNoXXX does not seem to complete before the UserForm displays. The FindLastNoXXX code needs to place a value in Cell AA5 prior to the UserForm opening. Any ideas? Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Dim rng Set rng = Cells(ActiveCell.Row, 1) If rng(1, 2).Value = "" Then Application.EnableEvents = False GoTo Finished End If If Not Application.Intersect(Target, Range("C7:V700")) Is Nothing Then 'NoShowDataInput.Show Call FindLastNoXXX.FindLastNoXXX NoShowDataInput.Show End If Finished: End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem running code | Excel Programming | |||
Problem with code to print - out of order | Excel Programming | |||
proper syntax order | Excel Worksheet Functions | |||
Code running order | Excel Programming | |||
Tab Order Code Problem | Excel Programming |