View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Create Sticky (Always-on-top) Popup

Look into making a userform and ".Show, vbModeless".
You can change the text by setting the .Caption of a label on the userform :
UserForm1.Label1.Cation="Some new text"

Otherwise, explain what you mean by "sticky".

NickHK

"0-0 Wai Wai ^-^" wrote in message
...

I'm new to VBA.

1) How can I create a sticky (Always-on-top) popup
MsgBox "This message is sticky"
The above code will pop up a dialog, but how to make it sticky?

2) How to create a function which customize the content of the popup?
I would like to create a function like this:
Fictional Code: Function Messagebox(text, sticky_or_not)

Thank you.

--
Additional info about my computer:
- Office XP
- Windows XP Pro