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

i use the code
CreateObject("WScript.Shell").popup strTextMessage, 1

for having an alert without pressing any key.

Can i rename the caption of the vbOk commandbutton???

Tia

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default vbok caption

Cause i dont want that that user press ANY key.

The number 1 means it appear ony 1 second long and then it close
automatically.

My question is:
Can i rename the caption of vbok?

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default vbok caption

This is in VBA is it ?
Why not just use MsgBox ?

NickHK

"I Love it" wrote in message
oups.com...
i use the code
CreateObject("WScript.Shell").popup strTextMessage, 1

for having an alert without pressing any key.

Can i rename the caption of the vbOk commandbutton???

Tia



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default vbok caption

I suggest you post in a scripting group then.

NickHK

"I Love it" wrote in message
oups.com...
Cause i dont want that that user press ANY key.

The number 1 means it appear ony 1 second long and then it close
automatically.

My question is:
Can i rename the caption of vbok?



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default vbok caption

did i get this code in this newsgroup?



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

You probably did.

When you say can you change the vbOK button, do you realise that you can use
the same buttons that MsgBox supports, you know, vbYesNo, vbOKCancel,
vbInformation, etc.

If you want your own text, I have used APIs to do this with MsgBox, but
never tried with the timed MsgBox.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"I Love it" wrote in message
oups.com...
did i get this code in this newsgroup?



  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default vbok caption

I'd be surprised.
Where do you think you are ?

NickHK

"I Love it" wrote in message
oups.com...
did i get this code in this newsgroup?



  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default vbok caption

Cant you stop to be so childish?
I need to use it and you're only wasting time.

I got all what i know thans to Bob, tom and Chip.
So who are you ??


"NickHK" ha scritto nel messaggio
...
I'd be surprised.
Where do you think you are ?

NickHK

"I Love it" wrote in message
oups.com...
did i get this code in this newsgroup?





  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default vbok caption

I can't see responses from Chip or Tom in this thread. What are you
referring to, as I would just like to read them?

thanks

Bob


"Paula" wrote in message
...
Cant you stop to be so childish?
I need to use it and you're only wasting time.

I got all what i know thans to Bob, tom and Chip.
So who are you ??


"NickHK" ha scritto nel messaggio
...
I'd be surprised.
Where do you think you are ?

NickHK

"I Love it" wrote in message
oups.com...
did i get this code in this newsgroup?







  #10   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default vbok caption

I meant that i'm expert in excel thanks to your help, Chip and Tom.





  #11   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default vbok caption

Oh right, just thought I was missing a post from those guys, and like you, I
like to read 'em :-)

Regards

Bob


"Paula" wrote in message
...
I meant that i'm expert in excel thanks to your help, Chip and Tom.





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
Caption Property the dude Excel Discussion (Misc queries) 1 June 1st 06 10:23 AM
Table Caption AA2e72E Excel Programming 2 February 7th 05 02:16 PM
VbOk not responding Myriam Excel Programming 3 December 1st 04 03:51 PM
Caption No Name Excel Programming 2 September 23rd 04 01:27 PM
caption sensitivity solo_razor[_30_] Excel Programming 2 November 10th 03 06:30 PM


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