Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Customizing buttons VBA

Hi,

I would like to know how to customize the buttons with the function MsgBox in VBA???

Thank you
Stephane
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 93
Default Customizing buttons VBA

If you mean how can you change the caption on the buttons displayed by MsgBox, the answer is you can't. If you need to, design your own form for displaying messages.
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Customizing buttons VBA

Hi Stephane

Look at the buttons argument in the VBA help
MsgBox "Hi", vbInformation

If you don't mean this then

You can't
Make your own MsgBox with a userform

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Stephane" wrote in message om...
Hi,

I would like to know how to customize the buttons with the function MsgBox in VBA???

Thank you
Stephane



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Customizing buttons VBA

or you can check out my previous post on the subject at

http://tinyurl.com/2qalu

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ron de Bruin" wrote in message
...
Hi Stephane

Look at the buttons argument in the VBA help
MsgBox "Hi", vbInformation

If you don't mean this then

You can't
Make your own MsgBox with a userform

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Stephane" wrote in message

om...
Hi,

I would like to know how to customize the buttons with the function

MsgBox in VBA???

Thank you
Stephane





  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Customizing buttons VBA

You are a real API lover Bob<g

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Bob Phillips" wrote in message ...
or you can check out my previous post on the subject at

http://tinyurl.com/2qalu

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ron de Bruin" wrote in message
...
Hi Stephane

Look at the buttons argument in the VBA help
MsgBox "Hi", vbInformation

If you don't mean this then

You can't
Make your own MsgBox with a userform

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Stephane" wrote in message

om...
Hi,

I would like to know how to customize the buttons with the function

MsgBox in VBA???

Thank you
Stephane









  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Customizing buttons VBA

I sure am - the power of the OS.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ron de Bruin" wrote in message
...
You are a real API lover Bob<g

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Bob Phillips" wrote in message

...
or you can check out my previous post on the subject at

http://tinyurl.com/2qalu

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ron de Bruin" wrote in message
...
Hi Stephane

Look at the buttons argument in the VBA help
MsgBox "Hi", vbInformation

If you don't mean this then

You can't
Make your own MsgBox with a userform

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Stephane" wrote in message

om...
Hi,

I would like to know how to customize the buttons with the function

MsgBox in VBA???

Thank you
Stephane








  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Customizing buttons VBA

Hi Ron
seems to be his real passion :-)

-----Original Message-----
You are a real API lover Bob<g

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Bob Phillips" wrote

in message news:%23Vb5%
...
or you can check out my previous post on the subject at

http://tinyurl.com/2qalu

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing

direct)

"Ron de Bruin" wrote in

message
...
Hi Stephane

Look at the buttons argument in the VBA help
MsgBox "Hi", vbInformation

If you don't mean this then

You can't
Make your own MsgBox with a userform

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Stephane" wrote in message

om...
Hi,

I would like to know how to customize the buttons

with the function
MsgBox in VBA???

Thank you
Stephane






.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Customizing -2^2 Tim Walters Excel Discussion (Misc queries) 7 December 7th 09 01:13 AM
have toggle buttons but everytime print preview buttons move TinSandhu Excel Discussion (Misc queries) 1 October 11th 06 02:57 PM
Customizing Toolbar Buttons Leo Minervini Excel Discussion (Misc queries) 0 April 6th 05 02:17 AM
Customizing toolbar buttons Alex[_18_] Excel Programming 1 February 25th 04 06:32 PM
Customizing the Legend Phil Hageman Excel Programming 1 July 18th 03 01:27 PM


All times are GMT +1. The time now is 01:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"