Thanks in advance for taking a look at the issue we are having and helping with a solution!
We have recorded a Macro with a textbox (Insert Textbox - not a shape with text or Active X text box). We want to add this textbox wherever we want to on the sheet.
In other macros, once they were recorded, I deleted the selected range and this allowed us to place the macro wherever we wanted.
What do I have to change/add to allow us to place this macro wherever we want to?
Sub IntlShipment()
'
' IntlShipment Macro
'
' Keyboard Shortcut: Ctrl+Shift+I
'
ActiveSheet.Shapes.AddTextbox(msoTextOrientationHorizontal, 79.5, 25.5, 223.5, _
75.75).Select
Selection.ShapeRange.Height = 66.96
Selection.ShapeRange.TextFrame2.TextRange.Font.Size = 8
Selection.ShapeRange.TextFrame2.TextRange.Font.Bold = msoTrue
Selection.ShapeRange.TextFrame2.TextRange.Font.Bold = msoFalse
Selection.ShapeRange.TextFrame2.TextRange.Font.Italic = msoTrue
Selection.ShapeRange.TextFrame2.TextRange.Font.UnderlineStyle = _
msoUnderlineSingleLine
Selection.ShapeRange(1).TextFrame2.TextRange.Characters.Text = _
"International and Canada Shipments"
Selection.ShapeRange(1).TextFrame2.TextRange.Characters(1, 34).ParagraphFormat. _
FirstLineIndent = 0
With Selection.ShapeRange(1).TextFrame2.TextRange.Characters(1, 34).Font
.Bold = msoFalse
.NameComplexScript = "+mn-cs"
.NameFarEast = "+mn-ea"
.Fill.Visible = msoTrue
.Fill.ForeColor.ObjectThemeColor = msoThemeColorDark1
.Fill.ForeColor.TintAndShade = 0
.Fill.ForeColor.Brightness = 0
.Fill.Transparency = 0
.Fill.Solid
.Size = 8
.Italic = msoTrue
.Name = "+mn-lt"
.UnderlineStyle = msoUnderlineSingleLine
End With
End Sub
We have recorded a Macro with a textbox (Insert Textbox - not a shape with text or Active X text box). We want to add this textbox wherever we want to on the sheet.
In other macros, once they were recorded, I deleted the selected range and this allowed us to place the macro wherever we wanted.
What do I have to change/add to allow us to place this macro wherever we want to?
Sub IntlShipment()
'
' IntlShipment Macro
'
' Keyboard Shortcut: Ctrl+Shift+I
'
ActiveSheet.Shapes.AddTextbox(msoTextOrientationHorizontal, 79.5, 25.5, 223.5, _
75.75).Select
Selection.ShapeRange.Height = 66.96
Selection.ShapeRange.TextFrame2.TextRange.Font.Size = 8
Selection.ShapeRange.TextFrame2.TextRange.Font.Bold = msoTrue
Selection.ShapeRange.TextFrame2.TextRange.Font.Bold = msoFalse
Selection.ShapeRange.TextFrame2.TextRange.Font.Italic = msoTrue
Selection.ShapeRange.TextFrame2.TextRange.Font.UnderlineStyle = _
msoUnderlineSingleLine
Selection.ShapeRange(1).TextFrame2.TextRange.Characters.Text = _
"International and Canada Shipments"
Selection.ShapeRange(1).TextFrame2.TextRange.Characters(1, 34).ParagraphFormat. _
FirstLineIndent = 0
With Selection.ShapeRange(1).TextFrame2.TextRange.Characters(1, 34).Font
.Bold = msoFalse
.NameComplexScript = "+mn-cs"
.NameFarEast = "+mn-ea"
.Fill.Visible = msoTrue
.Fill.ForeColor.ObjectThemeColor = msoThemeColorDark1
.Fill.ForeColor.TintAndShade = 0
.Fill.ForeColor.Brightness = 0
.Fill.Transparency = 0
.Fill.Solid
.Size = 8
.Italic = msoTrue
.Name = "+mn-lt"
.UnderlineStyle = msoUnderlineSingleLine
End With
End Sub