Specifying Location for a Message Box

In response to Bob D:

Here is the full function for setting up a window at a specific location using MsgBoxPos. It can be made safer using #if #else #end if on the declaration of .dll functions but this should work regardless.

___________________________________________________________________________________________________________________________
Code Modified by Riley Carney: https://www.linkedin.com/in/riley-carney-34141563/
Multiple online resources were used.
___________________________________________________________________________________________________________________________
Option Explicit

'Function Declaration
Private Declare Function GetWindowText Lib "user32" Alias "GetWindowTextA" _
(ByVal hwnd As Long, _
ByVal lpString As String, _
ByVal cch As Long) As Long
Private Declare Function UnhookWindowsHookEx Lib "user32" _
(ByVal hHook As Long) As Long
Private Declare Function GetCurrentThreadId Lib "kernel32" () As Long
Private Declare Function SetWindowsHookEx Lib "user32" _
Alias "SetWindowsHookExA" _
(ByVal idHook As Long, _
ByVal lpfn As Long, _
ByVal hmod As Long, _
ByVal dwThreadId As Long) As Long
Private Declare Function SetWindowPos Lib "user32" _
(ByVal hwnd As Long, _
ByVal hWndInsertAfter As Long, _
ByVal x As Long, _
ByVal y As Long, _
ByVal cx As Long, _
ByVal cy As Long, _
ByVal wFlags As Long) As Long

'Variable Declaration
Private hHook As Long
Private MsgBoxCaption As String
Private msgbox_x As Long
Private msgbox_y As Long

'Constant Declaration
Private Const WH_CBT = 5
Private Const HCBT_ACTIVATE = 5
Private Const SWP_NOSIZE = &H1
Private Const SWP_NOZORDER = &H4

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'Function: msgBoxPos
'Input: strPromt - a String for the text of the MsgBox
' vbButtons - a VbMsgBoxStyle based on how the MsgBox should be styled
' strTitle - a String for the title of the MsgBox
' xPos - a Long for the x-coordinate on where the MsgBox should be placed on the screen
' yPos - a Long for the y-coordinate on where the MsgBox should be placed on the screen
'Purpose: To display a message box at an (x,y) coordinate on the pixel mapping of the screen
' Note: If you want to do a point mapping you will need to create a function which finds the pixels per point of your screen
'Returns: VbMsgBoxResult : Based on user-input
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Public Function msgBoxPos(strPromt As String, _
vbButtons As VbMsgBoxStyle, _
strTitle As String, _
xPos As Long, _
yPos As Long) As VbMsgBoxResult
msgbox_x = xPos
msgbox_y = yPos
MsgBoxCaption = strTitle
hHook = SetWindowsHookEx(WH_CBT, _
AddressOf MsgBoxHookProc, _
0, _
GetCurrentThreadId)
msgBoxPos = MsgBox(strPromt, vbButtons, strTitle)
End Function

'Private Functions
Private Function MsgBoxHookProc(ByVal lMsg As Long, _
ByVal wParam As Long, _
ByVal lParam As Long) As Long
If lMsg = HCBT_ACTIVATE Then
If GetWinCaption(wParam) = MsgBoxCaption Then
SetWindowPos wParam, 0, msgbox_x, msgbox_y, _
0, 0, SWP_NOSIZE + SWP_NOZORDER
UnhookWindowsHookEx hHook
End If
End If
MsgBoxHookProc = False
End Function

Private Function GetWinCaption(WinHdl As Long) As String
Const BufSize As Long = 255
Dim Buffer As String * BufSize 'Use fixed-length buffer
Dim CaptionLen As Long
CaptionLen = GetWindowText(WinHdl, Buffer, BufSize)
If CaptionLen > 0 Then GetWinCaption = Left(Buffer, CaptionLen)
End Function

Hi Bob D

I can't get it to run, error on:
hHook = SetWindowsHookEx(WH_CBT, AddressOf WinProc1, hInst, Thread)

WinProc1 not defined

Regards

Greetings Allen,

Your post d/d 22081018 (08222018 in US speak?) regarding Positioning of Message Box refers.

Info below was published many years ago and still appears to work ok (at least with my 2007 version).

Perhaps it may be of interest.

Regards, Bob.


Option Explicit
Option Base 1

' http://support.microsoft.com/?scid=kb%3Ben-us%3B180936&x=11&y=12

Type RECT
Left As Long
Top As Long
Right As Long
Bottom As Long
End Type

Public Declare Function UnhookWindowsHookEx Lib "user32" _
(ByVal hHook As Long) As Long
Public Declare Function GetWindowLong Lib "user32" _
Alias "GetWindowLongA" (ByVal hwnd As Long, ByVal nIndex As Long) As Long
Public Declare Function SetWindowsHookEx Lib "user32" _
Alias "SetWindowsHookExA" (ByVal idHook As Long, ByVal lpfn As Long, _
ByVal hmod As Long, ByVal dwThreadId As Long) As Long
Public Declare Function SetWindowPos Lib "user32" _
(ByVal hwnd As Long, ByVal hWndInsertAfter As Long, _
ByVal x As Long, ByVal y As Long, ByVal cx As Long, _
ByVal cy As Long, ByVal wFlags As Long) As Long
Public Declare Function GetWindowRect Lib "user32" _
(ByVal hwnd As Long, lpRect As RECT) As Long
Public Declare Function GetCurrentThreadId Lib "kernel32" () As Long

Public Const GWL_HINSTANCE = (-6)
Public Const SWP_NOSIZE = &H1
Public Const SWP_NOZORDER = &H4
Public Const SWP_NOACTIVATE = &H10
Public Const HCBT_ACTIVATE = 5
Public Const WH_CBT = 5

Public hHook As Long

Sub Test_Go()
Dim hInst As Long
Dim Thread As Long
hInst = GetWindowLong(Application.hwnd, GWL_HINSTANCE)
Thread = GetCurrentThreadId()
hHook = SetWindowsHookEx(WH_CBT, AddressOf WinProc1, hInst, _
Thread)
MsgBox "This message box has been positioned at (0,0)."
End Sub

A User Form has also has the great advantage that you have control over the size colour and typeface of the text - which you don't have in a message box