+ Reply to Thread
Results 1 to 2 of 2

Update Color Change of Object From Data Validation List

  1. #1
    Registered User
    Join Date
    12-28-2011
    Location
    Here
    MS-Off Ver
    Excel 2007
    Posts
    43

    Update Color Change of Object From Data Validation List

    Hi All,
    I am attempting to solve a problem of changing the color of an object from a data validation list upon changing the value of the drop-down list.
    For example, I have two states, California and Alaska (the actual moveable outline) as objects within excel. When you select a drop-down list you can choose Alaska or California.
    When you choose one over the other I have two cells, L8 for Alaska, if selected will turn to an X or be False if not chosen and L9 for California with the same instance.

    If either is chosen I have set my code to change it's color.

    Please Login or Register  to view this content.
    The problem I am having is that when I select either state from the drop-down list, the color of the state does not change until you actually click off the drop-down list onto another cell.
    Automatic calculating is on and even you press F9 while still on the drop-down list it does not refresh the objects.
    I am not sure if it is something in my code that is causing the problem or if it is something that excel does poorly with objects.
    Any help would be greatly appreciated!

    -Bob

  2. #2
    Registered User
    Join Date
    12-28-2011
    Location
    Here
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: Update Color Change of Object From Data Validation List

    Still searching around for this.

    If anyone has any expertise in this area that would be fantastic.
    My test file is too big to post which is why I haven't attached anything.

    -Bob

+ 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