Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following little routine:
'=================== Private Sub CmdSelectData_Click() Me.Hide Call SelectDataRow Me.Show End Sub '=================== All looks fairly standard! The called routine, "SelectDataRow", is the following: '=================== Sub SelectDataRow() 'finds the last used row in the sheet that the user presently has active Dim LastUsedRow As Integer LastUsedRow = ActiveSheet.Cells(Rows.Count, 8).End(xlUp).Row 'get the user to select a row of data for moving to the Log Application.Calculation = xlCalculationAutomatic On Error Resume Next Set InvoiceRange = Application.InputBox("Either: " & vbCrLf & _ "1.Confirm the present selection by hitting OK" & vbCrLf & _ "2.Select a cell in another row and hit OK" & vbCrLf & _ "3.Hit CANCEL to stop the macro here", _ "RELEVANT PAYMENT INFORMATION", "A" & LastUsedRow & ":L" & _ LastUsedRow, , , , , 8) On Error GoTo 0 'if nothing has been selected on the activesheet then this is flagged to the user If InvoiceRange Is Nothing Then MsgBox "No cells on the ACTIVESHEET have been selected" End If End Sub '=================== The above looks pretty standard to me aswell. The problem is that when the code has run the routine SelectDataRow and then hits the line Me.Show the userform appears in a different position on the screen!! Do I need to change one of the userform's property's in Design Time - or will I need to write some extra code to be executed in run time? Any help greatly appreciated, Jason. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
X marks the spot | Excel Discussion (Misc queries) | |||
Hosur an IT hot spot? | Excel Worksheet Functions | |||
2 printers 1 does not print name in same spot | Excel Discussion (Misc queries) | |||
X marks the spot | Excel Programming | |||
I want a name in one spot and it's code in another | Excel Discussion (Misc queries) |