AW: Schließen einer Userform Blattwechsel verhindern
07.01.2006 18:06:47
Karl-Heinz
Hi Helga,
ich hoffe es ist einfach:
Private Sub UserForm_Initialize()
Dim frm As UserForm
Dim i As Integer
Dim iMax As Integer
Set frm = Filialreportdaten
Application.ScreenUpdating = False
With frm.ComboBoxOE
.Clear
iMax = Worksheets("Filialreport").UsedRange.Rows.Count
'iMax = ActiveSheet.UsedRange.Rows.Count
For i = 2 To iMax
.AddItem Worksheets("Filialreport").Cells(i, 1) & " " & Worksheets("Filialreport").Cells(i, 2)
Next i
End With
End Sub
Private Sub CommandButton1_Click()
Dim frm As UserForm
Dim index As Long
Dim OE As String
Set frm = Filialreportdaten
index = frm.ComboBoxOE.ListIndex
OE = frm.ComboBoxOE.ListIndex + 1
Sheets("Filialreport").Activate
Columns("A:A").Select
Selection.Find(What:=OE, After:=ActiveCell, LookIn:=xlValues _
, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Activate
Worksheets("Filialreport").Cells(ComboBoxOE.ListIndex + 2, 3).Select
Selection = frm.TextBox2.Text
End Sub
Private Sub commandbutton2_click()
Unload Me
End Sub
Gruß
Karl-Heinz