Results 1 to 8 of 8

Adding a textbox via command button

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-04-2006
    Posts
    151

    Adding a textbox via command button

    Good Day,

    I am trying to add a text box via command button, however, when I press the command button, nothing happens!
    My code is as follows:

    Private Sub addbox1_click()
    '
    ' Macro2 Macro
    ' Macro recorded 11/22/2006 by Jason
    '

    '
    ActiveSheet.Shapes.AddShape(msoShapeRectangle, 596.25, 177#, 132#, 45.75). _
    Select
    Selection.ShapeRange.Fill.Visible = msoFalse
    Selection.ShapeRange.Fill.Solid
    Selection.ShapeRange.Fill.Transparency = 0#
    Selection.ShapeRange.Line.Weight = 0.75
    Selection.ShapeRange.Line.DashStyle = msoLineSolid
    Selection.ShapeRange.Line.Style = msoLineSingle
    Selection.ShapeRange.Line.Transparency = 0#
    Selection.ShapeRange.Line.Visible = msoFalse
    End Sub


    Thanks!
    Last edited by NewExcelUser; 11-22-2006 at 09:45 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1