+ Reply to Thread
Results 1 to 7 of 7

Insert Excel Shape at Active Cell - Final help needed Please

  1. #1
    Registered User
    Join Date
    07-05-2009
    Location
    Bolton, England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Insert Excel Shape at Active Cell - Final help needed Please

    Hi I have this little piece of code that inserts a circle into my active worksheet, but I'm stuck as to how I make it appear at / on the currently activecell.

    Really grateful if anyone could advise please.

    Thanks

    Please Login or Register  to view this content.
    Last edited by PeterF; 12-26-2012 at 07:29 PM.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Insert Excel Shape at Active Cell - Final help needed Please

    Hi PeterF,

    Welcome to the forum.
    Hmmm . . . did you miss reading the rule about using code tags? Anytime you post VBA code you must use code tags.

    Before you receive help, edit your post to add the missing tags by highlighting all of the code then pressing button with the # symbol.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Registered User
    Join Date
    07-05-2009
    Location
    Bolton, England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Insert Excel Shape at Active Cell - Final help needed Please

    Oops' sorry, tags applied, certainly new and a novice, maybe too much Christmas spirit.......

  4. #4
    Forum Contributor
    Join Date
    08-09-2012
    Location
    British Columbia
    MS-Off Ver
    Excel 2010
    Posts
    189

    Re: Insert Excel Shape at Active Cell - Final help needed Please

    Had a similar challenge a while back and a search of this forum brought up this thread which helped.

    http://www.excelforum.com/excel-gene...-question.html

  5. #5
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,528

    Re: Insert Excel Shape at Active Cell - Final help needed Please

    Or something like this maybe


    Please Login or Register  to view this content.

  6. #6
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,528

    Re: Insert Excel Shape at Active Cell - Final help needed Please

    Forget about the previous code. No use setting a top (100) and left (100) and then changing it.


    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    07-05-2009
    Location
    Bolton, England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Insert Excel Shape at Active Cell - Final help needed Please

    Dear all, especially 'jolivanes' excellent help indeed, most grateful, solved the issue and helped further. Enjoy 2013 - Peter

+ 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