+ Reply to Thread
Results 1 to 2 of 2

macro to assign cell to shape

  1. #1
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Prefer Excel 2003 but 2007 is great!
    Posts
    1,155

    macro to assign cell to shape

    Hello all

    I have about 72 counties in the state of wisconsin that im trying to link to a cell.

    basically, i would like the county in the map i have in excel to show the name. the individual taht was here before me, got it to do it, but since he is not available, ive been provided this task.

    here is the formula

    Please Login or Register  to view this content.
    whenever i try to run this code, it giving an error. the county shapes already have names assigned them them, so they just have to link to the names starting in S6.

    can someone pls help me. in the end, i want to link two macros (see workbook) to the two buttons so the user can select to show either county name in the shape or revenue.

    the error im getting reads:
    "unable to set the formula property of the drawing class"

    pls help!

    cheers
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Prefer Excel 2003 but 2007 is great!
    Posts
    1,155

    Re: macro to assign cell to shape

    any suggestions guys?

+ 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