Why isn't this working? I am sure this is the code where you open a workbook, a pop up msgbox contains "Hello" text will appear. For my case, it has no respond.
Please Login or Register to view this content.
My filename is Book1.xls. Does the filename affect this?
I have copied this very code in Sheet1 tab.
Help.
Last edited by eddykk; 02-19-2009 at 04:57 AM.
The code actually needs to be in the "ThisWorkbook" section of code, not sheet 1.
See attached.
Ah, I get what you mean. Thanks beeawwb.
Now,
- How do I get the text centered allignment? The default is left indented.
- How do I insert a picture on this pop up window? Is .jpeg able to insert? Or at least an object like shapes or textbox.
For example (with centered allignment),
By: Edmund.
Location: World.
Special Thanks to: Karen, Sophia.
And also, there is a picture of a logo company at the top left corner of the pop up window.
It's ok, all done with userform.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks