在Excel按钮之间传输值 [英] Transfer values between Excel buttons

问题描述

有没有一种方法可以在Excel功能区中的两个Excel按钮之间传输值. 例如单击button1-保存一个值，说x 单击button2-检索相同的值x

Is there a way to transfer values between two Excel buttons in Excel ribbon. e.g. click of button1 - save a value say x click of button2 - retrieve the same value x

注意:我不想使用本地存储.

Note : I don't want to use local storage.

会话存储和文档存储似乎无法正常工作.

Session storage & document storage do not seem to work.

推荐答案

假设您使用的是加载项命令和一个"functions.js"文件来驱动操作，那么我不明白为什么您不能在function.js中存储一个全局变量(或其局部版本)以保持和传递值.

Assuming you are using add-in commands, and a single "functions.js" file to drive the actions, I don't see why you couldn't store a global variable (or some localized version thereof) within functions.js to keep and pass around the values.

这篇关于在Excel按钮之间传输值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！