really simple question.
Can I centre the text in a standard msgbox or do I have to produce a userform to have centered text?
If the former is possible how do i do this?
Thanks in advance
PS Sorry for the spelling mistake in the title!
really simple question.
Can I centre the text in a standard msgbox or do I have to produce a userform to have centered text?
If the former is possible how do i do this?
Thanks in advance
PS Sorry for the spelling mistake in the title!
I think you can do it using windows hooks, but it's probably easier to create your own userform.
Regards,
Rory
Microsoft MVP - Excel
Fair enough, I shall create a userform then, which should nicely keep me occupied till tea time.
By the way, I have no idea what windows hooks are, do you have time for a quick explination?
spelling in title corrected.
You can edit your own thread and change the title I think.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
There's a very good and, as it happens, on-topic explanation here
Regards,
Rory
Microsoft MVP - Excel
Rory: thanks for the link am reading it now (or will be when I've finished writing this.
Lucas: Thanks for changing the title, have figured out how to edit the post itself but couldn't see how to edit the title, so thanks
I "know" Colo has some code to centre (spelling is correct so please leave it !) text in message boxes, I seem to recall it uses fonts and places text temporarily in a cell to get the required spacings, go to JMT at http://www.puremis.net/excel/cgi-bin/yabb/YaBB.pl and look in the addins section.
2+2=9 ... (My Arithmetic Is Mental)
spelling is wrong and it's the wrong color
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
It's not coloured it's in plain Aluminium finish !
2+2=9 ... (My Arithmetic Is Mental)
good one...
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln