+ Reply to Thread
Results 1 to 5 of 5

A change of row height triggers the display of the new height value in a cell

  1. #1
    Registered User
    Join Date
    09-25-2023
    Location
    France
    MS-Off Ver
    o365
    Posts
    5

    Question A change of row height triggers the display of the new height value in a cell

    Hi

    I'm looking for a way to adjust manually the percentage of ingredients in a recipe
    and then, while adjusting it, I would like to see some depending values evolving accordingly (calories, fat...).

    ► ideally it could be a pie chart:
    I wish I could increase or decrease a sector with the mouse!
    But as far as I know, it's not possible anymore.

    The feature has been deprecated since Excel 2007.
    edit : still doable with Insert menu, Object, Create from file: Microsoft Graph Chart (Graph.exe).

    And the Manipulate Points on Charts (MPOC) Add-In is no longer compatible with O365
    Attached Images Attached Images
    Last edited by MatX; 09-25-2023 at 12:17 PM.

  2. #2
    Registered User
    Join Date
    09-25-2023
    Location
    France
    MS-Off Ver
    o365
    Posts
    5

    Re: A change of height triggers the display of the new height value in the cell

    ► As a workaround, I'd like to play with the row heights.
    And it's quite ideal: I can reduce or increase a row or another just like I feel.

    I made a functionnal example file based on this excellent post from xlnitwit and kev_
    "event trigger via change in row height"

    but the change of height does not trigger the new calculus of values.
    And I don't want to clic on a button or a cell... as I'm looking for an optimum as I'm sliding
    Can I have some help please?

    ► Or any other idea on how to easily change the ratios of several (up to 10) values?

    Thanks
    Mat
    Attached Files Attached Files
    Last edited by MatX; 09-25-2023 at 10:52 AM.

  3. #3
    Forum Contributor
    Join Date
    11-12-2012
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2010, 2013, 2016, Office 365
    Posts
    507

    Re: A change of height triggers the display of the new height value in the cell

    Quote Originally Posted by MatX View Post

    but the change of height does not trigger the new calculus of values.
    try Worksheet_SelectionChange

  4. #4
    Registered User
    Join Date
    09-25-2023
    Location
    France
    MS-Off Ver
    o365
    Posts
    5

    Re: A change of row height triggers the display of the new height value in a cell

    Thanks, I tried both:
    Worksheet_Change (see in the attached file)
    Worksheet_SelectionChange

    and neither is on the fly.
    I requires to click on another cell or to modify another cell value...

  5. #5
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,223

    Re: A change of row height triggers the display of the new height value in a cell

    You can use something that has events.
    eg. MSForms.ScrollBar.

    Artik
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Add row height to a specific row based on the total height of the rows being hiidden
    By archvanarl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-25-2021, 09:59 PM
  2. index and match, constant array row height, but variable text row height
    By qwerty1945 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2020, 11:04 AM
  3. Replies: 0
    Last Post: 02-13-2016, 03:31 AM
  4. Replies: 4
    Last Post: 03-21-2015, 08:18 PM
  5. Replies: 2
    Last Post: 01-12-2015, 02:52 PM
  6. Replies: 17
    Last Post: 02-25-2009, 10:09 AM
  7. [SOLVED] need to dbl row height without changing height of cell next to it
    By Excel-Illiterate in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-15-2006, 08:15 PM

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