+ Reply to Thread
Results 1 to 1 of 1

Macro to Select Shape Based on Filter

  1. 06-15-2019, 04:28 AM #1
    saravanan1981
    saravanan1981 is offline
    Forum Contributor
    Join Date
    11-17-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    365

    Macro to Select Shape Based on Filter

    Hi,

    I have an excel sheet "Details" where I will enter the data in Column B, C and D.

    In column F I have a Filter Criteria. I need Macro to Select Shape in cells of column E based on filter criteria from Column F.

    The Criteria and related shape given on sheet "Variance".

    Also need macro to adjust the row height as per the data entered and wrap text but minimum height should be 21.60 to fit the shape.

    Please help with Code.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Show shape on cell select, Hide shape when cell is deselected
    By brendangroff in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-25-2016, 03:36 PM
  2. [SOLVED] Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank
    By vinaynaran in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2016, 08:47 AM
  3. Assign macro with parameter to shape based on shape location
    By bobo3127 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2014, 11:18 AM
  4. [SOLVED] A macro after setting onaction for a shape that will select the shape.
    By vonRobbo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2014, 11:34 PM
  5. Macro to Select Shape to Print
    By josephteh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-02-2014, 09:18 PM
  6. Select a shape based on a cell value and update the shape when value changes
    By BigAl99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2013, 12:06 PM
  7. VBA macro for select shape ('+' pointer)
    By Mark Joseph in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2012, 11:11 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1