+ Reply to Thread
Results 1 to 3 of 3

Creating and placing a text box in VBA

  1. #1
    Registered User
    Join Date
    10-08-2012
    Location
    NC
    MS-Off Ver
    Excel 2013
    Posts
    16

    Creating and placing a text box in VBA

    I have some code that selects a number of cells vertically (say for instance C6:C19), and I want to create a text box that sits perfectly on top of these cells (snaps to). What is the best way to create a text box that would go from the top left of C6 and to the bottom right of C19 in the above example?

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007
    Posts
    2,515

    Re: Creating and placing a text box in VBA

    .
    One resource :

    http://excel.tips.net/T002192_Sizing..._the_Same.html
    .
    .
    A VBA approach:

    Please Login or Register  to view this content.
    Another resource: http://stackoverflow.com/questions/2...t-to-cell-size
    Attached Files Attached Files
    Cats. Because People Suck.

    If someone has assisted you in any way, please be respectful to acknowledge it.
    Simply saying "Thank you" will suffice. If you are so moved, adding to their reputation by clicking
    <------ Add Reputation is a very nice gesture.
    When your question has been answered, Please mark the thread as SOLVED.

  3. #3
    Registered User
    Join Date
    10-08-2012
    Location
    NC
    MS-Off Ver
    Excel 2013
    Posts
    16

    Re: Creating and placing a text box in VBA

    Thank you! I haven't had a chance to try the code yet, but I'll be sure to post back when I do.

+ Reply to Thread

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