Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have too questions:
1) VBA code Selection.ShapeRange.TextFrame.MarginLeft = 0# Selection.ShapeRange.TextFrame.MarginRight = 0# Selection.ShapeRange.TextFrame.MarginTop = 0# Selection.ShapeRange.TextFrame.MarginBottom = 0# seems to don't work. I have to click off <inside Margin <checkbox Automatic manually to get it in function 2) What is difference between Selection.ShapeRange.TextFrame.MarginLeft = 0# or ActiveSheet.Shapes.AddShape(msoShapeRectangle, 405#, 195#, 67.5, 46.5).Select And Selection.ShapeRange.TextFrame.MarginLeft = 0 or ActiveSheet.Shapes.AddShape(msoShapeRectangle, 405, 195, 67.5, 46.5).Select Any assistance would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting Footers from Margin to Margin | Excel Discussion (Misc queries) | |||
Setting right-hand internal margin in textbox | Excel Programming | |||
Textbox margin overwritten by auto-margin | Excel Programming | |||
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming |