Consulting

Results 1 to 2 of 2

Thread: Replace Chart labels with Textboxs

  1. #1
    VBAX Newbie
    Joined
    Jul 2011
    Location
    Bangalore
    Posts
    1
    Location

    Replace Chart labels with Textboxes

    Hi All,

    I'm struggling with a chart label formatting issue, any help with this regard is much appreciated.

    Issue Description:

    I was searching for a code to replace chart lables with textbox (as chart labels cant be resized) and I found some code on net to do this, however the textbox size comes out as 2.5 and it puts the textboxes onto the leftside of the chart and not exactly at the original label position.

    1) Is it possible to generate text boxes that are not part of the chart. The main advantage of doing it this way is that I can select muliple boxes - then can do all sorts of formatting (including moving them around) on lots of boxes at the same time. I don't think I can do this with text boxes imbedded within the chart.

    2) Is there a way to put the textbox exactly on the label.


    I have attached the relavant file for your reference.

    Regards,
    Mano
    Attached Files Attached Files
    Last edited by Mano; 07-13-2011 at 01:35 AM.

  2. #2
    VBAX Expert CatDaddy's Avatar
    Joined
    Jun 2011
    Posts
    581
    Location
    [VBA]
    yourTextBoxObject.linkedcell = "$A$1" ' or whichever cell you wish to link it to
    [/VBA]
    http://vbadud.blogspot.com/2008/07/l...nge-using.html
    ------------------------------------------------
    Happy Coding my friends

Posting Permissions

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