Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Position Wordart in Page Center

This userform dumps blue wordart onto a apge. It require the left and
right variables. I want the text to be positioned in the center. I
tried ".Pageheight/2" and similar variations but i can;t figure it out.
Any ideas how to make the left and top values variable based on project
size?

--------------------------------------------------------
Private Sub CommandButton1_Click()

Dim shpWordArt As Shape

Set shpWordArt = ActiveDocument.Pages(1).Shapes.AddTextEffect _
(PresetTextEffect:=msoTextEffect7, Text:=TextBox1.Value, _
FontName:="Nino Salvaggio Sign", FontSize:=125, _
FontBold:=msoFalse, FontItalic:=msoFalse, _
Left:=144, Top:=72)

shpWordArt.Fill.ForeColor.RGB = RGB(Red:=0, Green:=0, blue:=255)

TextBox1.Value = ""
TextBox1.SetFocus
Unload bluetext

End Sub

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
center table on page JWA Excel Discussion (Misc queries) 3 December 3rd 08 03:16 PM
How do you Position WordArt behind data Kay Excel Worksheet Functions 0 July 30th 08 11:49 PM
How do I center words on a page? Midnite Excel Discussion (Misc queries) 6 February 22nd 08 11:59 PM
UserForm position other than center of the screen. Jay Fincannon Excel Programming 1 January 23rd 05 02:23 AM
Hiding Shapes When Not WordArt , or When WordArt Text < "Draft" Carroll Rinehart Excel Programming 2 September 18th 04 07:40 PM


All times are GMT +1. The time now is 12:21 PM.

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"