用于在Excel中搜索工作表的搜索框 [英] A search box to search for a worksheet in Excel
问题描述
有谁能让我知道如何创建一个搜索框来搜索某个工作表并在Excel文件中显示该特定工作表?假设我喜欢45个工作表,并希望按名称搜索工作表并显示该特定工作表。考虑
me作为创建宏的行为,而行话较少,答案会很好。
Can anyone let me know how to create a search box which would search for a certain worksheet and display that particular sheet in Excel file? Say I've like 45 worksheets and want to search for the sheet by it's name and display that particular sheet. Consider me as a tyro in creating macros and jargon less answer would be great.
感谢您的帮助。
Thanks for all your help.
推荐答案
您好,
这是讨论微软问题和反馈的论坛Excel功能,我会将您的问题转移到Excel的MSDN论坛
This is the forum to discuss questions and feedback for Microsoft Excel features, I'll move your question to the MSDN forum for Excel
https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev
https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev
我们建议适当发布的原因是您将获得最合格的受访者群体,而定期阅读论坛的其他合作伙伴可以分享他们的知识或从您与我们的互动中学习。感谢您的理解。
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.
问候,
Emi
这篇关于用于在Excel中搜索工作表的搜索框的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!