将鼠标悬停在带有宏和visual basic的条形图图表上时,如何复制显示的y值? [英] How do I copy a y value shown when hovering over a bar graph chart with macros and visual basic?
问题描述
的嗨!当我使用Visual Basic宏将鼠标悬停在Excel中的条形图栏上时,有没有办法复制显示的值?我的图表数据位于单独的电子表格中,我相信它会显示某个单元格中图表的y值。你能帮忙编码吗?任何帮助将不胜感激!!
谢谢!!
我尝试过的:
我试过调整复制并粘贴宏来显示突出显示的值的总和,但不知道如何描述悬停时显示的图表对象使用鼠标的图形。
Hi! Is there a way to copy the value shown when I hover over a bar graph bar in Excel using a Visual Basic macro? My chart data is on a separate spreadsheet and I believe is showing the y value of the chart from a certain cell. Can you help with the coding? Any assistance would be much appreciated!!
Thanks!!
What I have tried:
I have tried tweaking a copy and paste macro for sums of highlighted values but don't know how to describe the chart object shown when hovering over the graph with the mouse.
推荐答案
一些建议:将鼠标悬停在Excel中的条形图栏上 - Google搜索 [ ^ ]。
这篇关于将鼠标悬停在带有宏和visual basic的条形图图表上时,如何复制显示的y值?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!