右键单击没有excel
Your challenge for today is to come up with a real-life use for this nifty (do the kids still say nifty?) Excel scrolling tool.
今天的挑战是为这种漂亮的(孩子们还在说漂亮吗?)Excel滚动工具提供现实的用途。
Here’s how the tool works:
该工具的工作方式如下:
- Click a button to select a group of cells that you want to work with, like this list of months. 单击一个按钮以选择要使用的一组单元格,例如以下月份列表。
- Then, click the up and down arrows, to scroll the list through the selected cells. 然后,单击向上和向下箭头,以在选定的单元格中滚动列表。
- When you’re done, click the Exit button, to “release” the scroll area. 完成后,单击“退出”按钮,以“释放”滚动区域。
移动清单项目 (Move List Items)
In this example, the scrolling list is in cells D8:E19 – months and numbers. The original list had January at the top, and February in the second row. I clicked the Up arrow twice, and now March is at the top of the list.
在此示例中,滚动列表位于单元格D8:E19中-月份和数字。 原始列表的顶部是一月,第二行是二月。 我单击了两次向上箭头,现在三月在列表的顶部。
![scrollitems01 scrollitems01](https://i-blog.csdnimg.cn/blog_migrate/f89626d92edb63c3e95d38b718102d51.png)
使用前的注意事项 (Cautions Before Using)
In his sample file, Jim lists a few things to consider, before you use the code in one of your own files.
在使用示例文件中的代码之前,Jim在示例文件中列出了一些要考虑的事项。
-
- Cell interior colors 电池内部颜色
- Conditional Formatting 条件格式
- Data Validation 资料验证
- Formulas 公式
- Merged cells 合并细胞
- Undo (on the edit menu) will not undo custom scrolling. 撤消(在编辑菜单上)不会撤消自定义滚动。
可能的用途 (Possible Uses)
Jim Cone sent me this file, because he thought it was a unique tool, but he couldn’t think of a practical use for it. He wondered if an Excel slot machine was possible.
Jim Cone向我发送了这个文件,因为他认为这是一个独特的工具,但他想不出它的实际用途。 他想知道是否可以使用Excel老虎机。
I don’t have any ideas, but maybe the Blue Jays could use it to rotate their starting lineup, now that baseball season is underway.
我没有任何想法,但是既然棒球赛季已经开始,也许蓝鸟队可以用它来改变他们的首发阵容。
Do you have any suggestions, brilliant or otherwise?
您有什么建议吗?
下载样本文件 (Download the Sample File)
To see the scrolling tool, and the code that runs it, you can download Jim’s sample file from my Contextures website. On the Sample Files page, go to the “UserForms, VBA, Add-Ins” section, and look for UF0021 – Scroll Items Up and Down in List
若要查看滚动工具及其运行代码,可以从我的Contextures网站下载Jim的示例文件。 在“示例文件”页面上,转到“用户窗体,VBA,加载项”部分,然后查找UF0021 –在列表中上下滚动项目
The VBA code is protected, and the password is: s
VBA代码受保护,密码为: s
And if you have any ideas or suggestions, please share them in the comments, or contact Jim at the address in the sample file. Thanks!
如果您有任何想法或建议,请在评论中分享,或通过示例文件中的地址联系Jim。 谢谢!
翻译自: https://contexturesblog.com/archives/2013/04/18/click-to-move-excel-list-items-up-or-down/
右键单击没有excel