Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I get
Private Sub UserForm_Activate() Application.Wait Now + TimeValue("00:00:03") Unload Me Application.ScreenUpdating = False Sheets("main").Select Application.ScreenUpdating = True End Sub to function with: SetWindowLong _ Lib "user32" _ Alias "SetWindowLongA" ( _ ByVal hwnd As Long, _ ByVal nIndex As Long, _ ByVal dwNewLong As Long) _ As Long Private Declare Function FindWindow _ Lib "user32" _ Alias "FindWindowA" ( _ ByVal lpClassName As String, _ ByVal lpWindowName As String) _ As Long Private Sub UserForm_Initialize() SetWindowLong FindWindow(vbNullString, Me.Caption), _ -16, -2067791744 End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lib parameter in Function Declare | Excel Programming | |||
Declare and array in a function | Excel Programming | |||
How do I declare a function whose output is an array? | Excel Programming | |||
How can use LONGLONG type of C++ Dll in 'Declare Function' statement? | Excel Programming | |||
Calling Private Sub/Function | Excel Programming |