Is their a way to change the title of the vbOKCancel buttons? I want to
change the buttons instead of saying "OK" and "Cancel" to say something else.
Is this possible?

Just delete "OKCancel" and type over it...to what ever you want.

"Jase" wrote:

Is their a way to change the title of the vbOKCancel buttons? I want to
change the buttons instead of saying "OK" and "Cancel" to say something else.
Is this possible?

Nope.

How about creating your own userform???

Jase wrote:

Is their a way to change the title of the vbOKCancel buttons? I want to
change the buttons instead of saying "OK" and "Cancel" to say something else.
Is this possible?

--

Dave Peterson

I am tring to stay away from forms, they have slowed my worksheet down in the
past.

"Dave Peterson" wrote:

Nope.

How about creating your own userform???

Jase wrote:

Is their a way to change the title of the vbOKCancel buttons? I want to
change the buttons instead of saying "OK" and "Cancel" to say something else.
Is this possible?

--

Dave Peterson

Hi,

You can change it but it isn't easy and the code below demonstrates how. I
copied it several years ago and never noted the original author but I think
it was Bob Philips. Apologies both to him and the original author if my
mempry has let me down. the code includes a couple of test subs at the end as
examples of how it works. Me; while I can appreciate the code, I wouldn't
bother.

Mind out for line wraps. It goes in an ordinary module.

Option Explicit

Private Declare Function GetCurrentThreadId Lib "kernel32" _
() As Long
Public Declare Function GetDesktopWindow Lib "user32" _
() As Long
Private Declare Function GetWindowLong Lib "user32" _
Alias "GetWindowLongA" _
(ByVal hWnd As Long, _
ByVal nIndex As Long) As Long
Private Declare Function MessageBox Lib "user32" _
Alias "MessageBoxA" _
(ByVal hWnd As Long, _
ByVal lpText As String, _
ByVal lpCaption As String, _
ByVal wType As Long) As Long
Private Declare Function SetDlgItemText Lib "user32" _
Alias "SetDlgItemTextA" _
(ByVal hDlg As Long, _
ByVal nIDDlgItem As Long, _
ByVal lpString As String) 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 SetWindowText Lib "user32" _
Alias "SetWindowTextA" _
(ByVal hWnd As Long, _
ByVal lpString As String) As Long
Private Declare Function UnhookWindowsHookEx Lib "user32" _
(ByVal hHook As Long) As Long

Private Const IDPROMPT = &HFFFF&
Private Const WH_CBT = 5
Private Const GWL_HINSTANCE = (-6)
Private Const HCBT_ACTIVATE = 5

Private Type MSGBOX_HOOK_PARAMS
hWndOwner As Long
hHook As Long
End Type

Private MSGHOOK As MSGBOX_HOOK_PARAMS

Dim mbFlags As VbMsgBoxStyle
Dim mbFlags2 As VbMsgBoxStyle
Dim mTitle As String
Dim mPrompt As String
Dim But1 As String
Dim But2 As String
Dim But3 As String



'---------------------------------------------------------------------------
Public Function cMsgBox(hWnd As Long, _
mMsgbox As VbMsgBoxStyle, _
Title As String, _
Prompt As String, _
Optional mMsgIcon As VbMsgBoxStyle, _
Optional Button1 As String, _
Optional Button2 As String, _
Optional Button3 As String) As String

'---------------------------------------------------------------------------
' Function: Controls the display of the custom MsgBox and returns the
' selected button
' Synopsis: Sets supplied custom parameters and returns text of
' the button that was pressed as a string

'---------------------------------------------------------------------------
Dim mReturn As Long

mbFlags = mMsgbox
mbFlags2 = mMsgIcon
mTitle = Title
mPrompt = Prompt
But1 = Button1
But2 = Button2
But3 = Button3

'show the custom messagebox
mReturn = MessageBoxH(hWnd, GetDesktopWindow(), mbFlags Or mbFlags2)

'test which button of the 7 possible options has been pressed
Select Case mReturn
Case vbAbort
cMsgBox = But1
Case vbRetry
cMsgBox = But2
Case vbIgnore
cMsgBox = But3
Case vbYes
cMsgBox = But1
Case vbNo
cMsgBox = But2
Case vbCancel
cMsgBox = But3
Case vbOK
cMsgBox = But1
End Select

End Function

'---------------------------------------------------------------------------

Public Function MessageBoxH(hWndThreadOwner As Long, _
hWndOwner As Long, _
mbFlags As VbMsgBoxStyle) As Long
'---------------------------------------------------------------------------

' Function: Calls the hook
'---------------------------------------------------------------------------

Dim hInstance As Long
Dim hThreadId As Long

hInstance = GetWindowLong(hWndThreadOwner, GWL_HINSTANCE)
hThreadId = GetCurrentThreadId()

With MSGHOOK
.hWndOwner = hWndOwner
.hHook = SetWindowsHookEx(WH_CBT, AddressOf MsgBoxHookProc,
hInstance, hThreadId)
End With

MessageBoxH = MessageBox(hWndOwner, Space$(120), Space$(120), mbFlags)

End Function

'---------------------------------------------------------------------------
Public Function MsgBoxHookProc(ByVal uMsg As Long, _
ByVal wParam As Long, _
ByVal lParam As Long) As Long
'---------------------------------------------------------------------------
'Function: Formats and shows the custom messagebox
' Synopsis: Setups the window text
' Setups the dialog box text
' Checks which buttons have been added to messagebox (choice
of 6
' combinations ofthe 7 buttons), then sets the button text
' accordingly
' Then removes the hook
'---------------------------------------------------------------------------

If uMsg = HCBT_ACTIVATE Then
SetWindowText wParam, mTitle
SetDlgItemText wParam, IDPROMPT, mPrompt

Select Case mbFlags
Case vbAbortRetryIgnore
SetDlgItemText wParam, vbAbort, But1
SetDlgItemText wParam, vbRetry, But2
SetDlgItemText wParam, vbIgnore, But3
Case vbYesNoCancel
SetDlgItemText wParam, vbYes, But1
SetDlgItemText wParam, vbNo, But2
SetDlgItemText wParam, vbCancel, But3
Case vbOKOnly
SetDlgItemText wParam, vbOK, But1
Case vbRetryCancel
SetDlgItemText wParam, vbRetry, But1
SetDlgItemText wParam, vbCancel, But2
Case vbYesNo
SetDlgItemText wParam, vbYes, But1
SetDlgItemText wParam, vbNo, But2
Case vbOKCancel
SetDlgItemText wParam, vbOK, But1
SetDlgItemText wParam, vbCancel, But2
End Select

UnhookWindowsHookEx MSGHOOK.hHook

End If

MsgBoxHookProc = False

End Function

Sub Test()
Dim mReturn As String
mReturn = cMsgBox(1, _
vbYesNoCancel, _
"Customize your message box buttons", _
"Do you not agree that this is pretty cool?", _
, _
"I Like It", _
"Not For Me", _
"I;ll Get Back To You")
cMsgBox 1, _
vbOKOnly, _
"Customize your message box buttons", _
"You selected the button captioned: " & mReturn, _
, _
"Okay"
End Sub


Sub test2()
Dim a
Dim ary
ary = Array("vbOKOnly", "vbOK", "vbCancel", "vbAbort", "vbRetry",
"vbIgnore", "vbYes", "vbNo")
a = MsgBox("Hello", vbAbortRetryIgnore)
MsgBox (ary(a))
End Sub


Mike

"Jase" wrote:

I am tring to stay away from forms, they have slowed my worksheet down in the
past.

"Dave Peterson" wrote:

Nope.

How about creating your own userform???

Jase wrote:

Is their a way to change the title of the vbOKCancel buttons? I want to
change the buttons instead of saying "OK" and "Cancel" to say something else.
Is this possible?

--

Dave Peterson

Yes, but very complicated and pretty unstable. Go for the userform:
http://www.dailydoseofexcel.com/arch...message-boxes/

HTH. Best wishes Harald

"Jase" skrev i melding
...
Is their a way to change the title of the vbOKCancel buttons? I want to
change the buttons instead of saying "OK" and "Cancel" to say something
else.
Is this possible?

Thanks, I ended up using a userform. Appreciate the help.

Cheers,

Jase

"Harald Staff" wrote:

Yes, but very complicated and pretty unstable. Go for the userform:
http://www.dailydoseofexcel.com/arch...message-boxes/

HTH. Best wishes Harald

"Jase" skrev i melding
...
Is their a way to change the title of the vbOKCancel buttons? I want to
change the buttons instead of saying "OK" and "Cancel" to say something
else.
Is this possible?

Hi,

I agree about complicated but using the code i posted eralier and this test
sub I think you'll find it fairly difficult to break it.

Sub Test()
Dim mReturn As String
Dim ttl As String
Dim msg As String
msg = "Do you not agree that this is pretty cool?"
ttl = "Customize your message box buttons"
mReturn = cMsgBox(1, vbYesNoCancel, ttl, msg, , "I Like It", "Not For Me",
"La8ter")
Select Case mReturn
Case "I Like It"
MsgBox "Run this sub"
Case "Not For Me"
MsgBox "Run That sub"
Case "La8ter"
MsgBox "Run the other Sub"
End Select
End Sub

Mike

"Harald Staff" wrote:

Yes, but very complicated and pretty unstable. Go for the userform:
http://www.dailydoseofexcel.com/arch...message-boxes/

HTH. Best wishes Harald

"Jase" skrev i melding
...
Is their a way to change the title of the vbOKCancel buttons? I want to
change the buttons instead of saying "OK" and "Cancel" to say something
else.
Is this possible?

I've managed before, Mike :-)
But if your experience is that it's stable, good. It deserves a try anyway.

Best wishes Harald


"Mike H" skrev i melding
...
Hi,

I agree about complicated but using the code i posted eralier and this
test
sub I think you'll find it fairly difficult to break it.