كيفية تكبير و تصغير اليوزرفورم Minimize & maximize في الاكسيل VBA

  Рет қаралды 108

Accounting App Unit

Accounting App Unit

8 күн бұрын

كود تكبير و تصغير اليوزرفورم
Private Declare PtrSafe Function FindWindow Lib "User32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare PtrSafe Function GetWindowLong Lib "User32" Alias "GetWindowLongA" (ByVal hwnd As Long, ByVal nIndex As Long) As Long
Private Declare PtrSafe Function SetWindowLong Lib "User32" Alias "SetWindowLongA" (ByVal hwnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long
Private Const GWL_STYLE As Long = (-16)
Private Const WS_THICKFRAME As Long = &H40000
Const MIN_BOX As Long = &H20000
Const MAX_BOX As Long = &H10000
Private Declare PtrSafe Function DrawMenuBar Lib "user32.dll" (ByVal hwnd As Long) As Long
Private Declare PtrSafe Function GetForegroundWindow Lib "user32.dll" () As Long
Public Sub AddToForm(ByVal Box_Type As Long)
Dim BisMask As Long
Dim Window_Handle As Long
Dim WindowStyle As Long
Dim Ret As Long
If Box_Type = MIN_BOX Or Box_Type = MAX_BOX Then
Window_Handle = GetForegroundWindow()
WindowStyle = GetWindowLong(Window_Handle, GWL_STYLE)
BisMask = WindowStyle Or Box_Type
Ret = SetWindowLong(Window_Handle, GWL_STYLE, BisMask)
Ret = DrawMenuBar(Window_Handle)
End If
End Sub
Private Sub UserForm_Activate()
Call AddToForm(MIN_BOX)
Call AddToForm(MAX_BOX)
End Sub

Пікірлер
Robotaxis | Big Ideas 2024
9:41
ARK Invest
Рет қаралды 34 М.
I CAN’T BELIEVE I LOST 😱
00:46
Topper Guild
Рет қаралды 105 МЛН
A clash of kindness and indifference #shorts
00:17
Fabiosa Best Lifehacks
Рет қаралды 35 МЛН
Me: Don't cross there's cars coming
00:16
LOL
Рет қаралды 15 МЛН
The Tools I Use to Build Products in Laravel
19:00
Josh Cirre
Рет қаралды 16 М.
Liked Pydantic? You'll LOVE Msgspec
15:53
Carberra
Рет қаралды 9 М.
Build Generalized DRY Angular Code with Generics
14:44
Deborah Kurata
Рет қаралды 6 М.
The Blind Date Show 2 - Episode 36 with Hind & Fady
20:17
BingeCircle
Рет қаралды 2,9 МЛН
Create Stunning Python GUIs in 10 Minutes With Drag & Drop
11:38
Coding Is Fun
Рет қаралды 21 М.
How To Structure Terraform Project (3 Levels)
41:21
Anton Putra
Рет қаралды 2,5 М.