Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default vbYesNo message box

Is it possible to have symbols or other captions instead of Yes and No on the
buttons as I need it to come up for a Welsh form. Thanks in advance

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default vbYesNo message box

Hi Big Mac,

Is it possible to have symbols or other captions instead of Yes and No
on the buttons as I need it to come up for a Welsh form.


Why not design your own userform?


---
Regards,
Norman


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default vbYesNo message box

That's the answer but I was hoping for a quick fix, that there was a way to
change the labels. Thanks
--



"Norman Jones" wrote:

Hi Big Mac,

Is it possible to have symbols or other captions instead of Yes and No
on the buttons as I need it to come up for a Welsh form.


Why not design your own userform?


---
Regards,
Norman



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 292
Default vbYesNo message box

No.
(Well, it is possible, but it is very complicated and really unstable)

HTH. Best wishes Harald

"Big Mac" skrev i melding
...
That's the answer but I was hoping for a quick fix, that there was a way
to
change the labels. Thanks
--



"Norman Jones" wrote:

Hi Big Mac,

Is it possible to have symbols or other captions instead of Yes and No
on the buttons as I need it to come up for a Welsh form.


Why not design your own userform?


---
Regards,
Norman





  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default vbYesNo message box

Hi Big Mac,

That's the answer but I was hoping for a quick fix, that there was a way
to
change the labels. Thanks


See Harald's adjacent post.

To customise the buttons - and if you are brave enough - see code posted by
Harald:

http://tinyurl.com/kbd86


---
Regards,
Norman




  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default vbYesNo message box

I recently uploaded this to Planet SourceCode:
http://www.planet-source-code.com/vb...65065&lngWId=1

This works with a VB6 ActiveX dll and will allow you to set the button
captions and a lot more.
Just download, unzip, set a reference with regsvr32 and then in your VBA
project set a reference to the
file via Tools, References in the VBE.

RBS


"Big Mac" wrote in message
...
Is it possible to have symbols or other captions instead of Yes and No on
the
buttons as I need it to come up for a Welsh form. Thanks in advance


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
vbYesNo, change carriage return jbjtc Excel Discussion (Misc queries) 4 September 28th 07 09:13 AM
VbYesNo MsgBox won't respond to "No" Peter Rooney Excel Programming 4 December 22nd 05 04:01 PM
VBYesNo MsgBox - Computer always says "Yes" Peter Rooney Excel Discussion (Misc queries) 4 December 22nd 05 02:42 PM
VbYesNo Msg Box mjack003 Excel Discussion (Misc queries) 1 September 22nd 05 03:09 AM
vbYesNo mike allen Excel Programming 1 January 4th 04 03:59 PM


All times are GMT +1. The time now is 11:15 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"