Как убрать заголовок формы - VBA
Формулировка задачи:
Подскажите пожалуйста, как заголовок формы убрать??
Спасибо
Решение задачи: «Как убрать заголовок формы»
textual
Листинг программы
Option Explicit
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare Function GetWindowLong Lib "user32" Alias "GetWindowLongA" (ByVal hwnd As Long, ByVal nIndex As Long) As Long
Private Declare Function SetWindowLong Lib "user32" Alias "SetWindowLongA" (ByVal hwnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long
Private Const GWL_STYLE = (-16)
Private Const WS_BORDER As Long = &H800000
Private Const WS_CAPTION As Long = &HC00000
Public Sub ChangeWindow(f As UserForm)
Dim hwnd As Long
Dim retval As Long
hwnd = FindWindow("ThunderDFrame", f.Caption)
If hwnd <> 0 Then
retval = SetWindowLong(hwnd, GWL_STYLE, GetWindowLong(hwnd, GWL_STYLE) And WS_BORDER)
End If
If retval = 0 Then MsgBox "Fail"
End Sub
Private Sub UserForm_Initialize()
ChangeWindow Me
End Sub