Private Sub CommandButton8_Click() 'printen formulier berekening Rc en U
With Me
For Each Ctrl In Frame2.Controls
If TypeName(Ctrl) = "TextBox" Then
Ctrl.BackColor = RGB(255, 255, 255)
End If
Next Ctrl
For Each Ctrl In Frame2.Controls
If TypeName(Ctrl) = "Label" Then
Ctrl.BackColor = RGB(255, 255, 255)
End If
Next Ctrl
.CommandButton7.Visible = False
.BackColor = RGB(255, 255, 255)
.Frame2.BackColor = RGB(255, 255, 255)
.Frame3.BackColor = RGB(255, 255, 255)
.Frame5.BackColor = RGB(255, 255, 255)
.Frame6.BackColor = RGB(255, 255, 255)
.Frame7.BackColor = RGB(255, 255, 255)
.Frame9.BackColor = RGB(255, 255, 255)
.Frame1.Visible = False
.Frame8.Visible = False
.Frame2.Top = .Frame2.Top
.Frame2.Top = .Frame1.Top
.Height = .Height - .Frame1.Height
.Height = .Height - 18
.Frame2.Height = 252
.Frame9.Left = .Frame9.Left
.Frame9.Left = .Frame8.Left
.Width = .Width - .Frame8.Width
.Frame2.Width = .Width - 25
End With
DoEvents
keybd_event VK_LMENU, 0, _
KEYEVENTF_EXTENDEDKEY, 0
keybd_event VK_SNAPSHOT, 0, _
KEYEVENTF_EXTENDEDKEY, 0
keybd_event VK_SNAPSHOT, 0, _
KEYEVENTF_EXTENDEDKEY + KEYEVENTF_KEYUP, 0
keybd_event VK_LMENU, 0, _
KEYEVENTF_EXTENDEDKEY + KEYEVENTF_KEYUP, 0
DoEvents
Workbooks.Add
With ActiveSheet.PageSetup
.Orientation = xlLandscape
.PaperSize = xlPaperA4
.CenterHorizontally = True
.CenterVertically = True
End With
Application.Wait Now + TimeValue("00:00:01")
ActiveSheet.PasteSpecial Format:="Bitmap", _
Link:=False, DisplayAsIcon:=False
ActiveSheet.Range("A1").Select
Unload Me
ActiveWindow.SelectedSheets.PrintPreview 'PrintOut
ActiveWorkbook.Close False
End Sub
Private Sub ListBox1_Click() 'listbox lambdawaardes en omschrijving
With ListBox1
If .ListIndex > -1 Then
TextBox17.Value = .List(.ListIndex, 1)
TextBox20.Value = .List(.ListIndex, 0)
End If
End With
If TextBox17.Value <> "" Then TextBox18.SetFocus
If TextBox17.Value = "" Then TextBox17.SetFocus
End Sub