体验零代码搭建

如何创建一个带有超链接的下拉列表到Excel中的每个工作表?

网友投稿  ·  2023-10-26 19:10  ·  所有内容  ·  阅读 817


如何创建一个带有超链接的下拉列表到Excel中的每个工作表?

如何创建一个带有超链接的下拉列表到Excel中的每个工作表?

也许您之前已经创建了一个下拉列表,但是您是否曾经创建过一个包含指向Excel中每个工作表的超链接的下拉列表,如下所示?

如何创建一个带有超链接的下拉列表到Excel中的每个工作表?

创建带有工作表超链接的下拉列表

创建带有超链接的工作表列表

使用工作表超链接创建一个下拉列表

只有VBA代码可以处理Excel中的作业。

1。 点击 开发商 > 插页 > 组合框(ActiveX控件)

.

注意:如果功能区中未显示开发人员选项卡,请单击 文件 > 附加选项 > 自定义功能区,然后检查 开发商

右框中的选项。 看截图:

2.然后在任意位置绘制一个组合框。

3.右键单击您刚才绘制的组合框的工作表,然后单击 查看代码

从上下文菜单。

4.将以下代码复制并粘贴到空白脚本中,然后保存以返回到工作表。

VBA:使用工作表链接创建下拉列表

Private Sub ComboBox1_Change() UpdatebyExtendoffice20180404 Sheets(Me.ComboBox1.Text).Select End Sub Private Sub ComboBox1_GotFocus() Dim I As Long Me.ComboBox1.Style = fmStyleDropDownList If Me.ComboBox1.ListCount <> Sheets.Count Then Me.ComboBox1.Clear For I = 1 To ActiveWorkbook.Sheets.Count Me.ComboBox1.AddItem Sheets(I).Name Next End If Me.ComboBox1.DropDown End Sub
Copy
5. Click Developer > Design Mode to exit the design mode. Now all sheets have been listed in the drop-down list, and it will go to the sheet while you clicking at the sheet name. Create a list of sheets with hyperlinks If you just want to create a list of clickable sheet names as below screenshot shown, you can apply Kutools for Excel’s Create List of Sheet Names feature which can create a list of hyperlinks about sheet names or list of macro buttons about sheet names. Kutools for Excel, with more than 300 handy functions, makes your jobs more easier. Free Downloadfree full-featured in 30 days After installing Kutools for Excel, please do as below:(Free Download Kutools for Excel Now!) 1. Click Kutools Plus > Worksheet > Create List of Sheet Names. 2. In the Create List of Sheet Names dialog, do as below: (1). Check Contains a list of hyperlinks< to create a list of clickable sheet names, or check Contains buttons and macros to create buttons which link to each sheet. (2). Give the new sheet which you will place the hyperlinks in a name. (3). Specify the location of the new sheet. (4). Specify the sheet links displayed as how many columns. 3. click Ok, now the clickable sheet names have been displayed in new sheet. Demo Best Office Productivity Tools Transform Hours into Minutes with Kutools for Excel! Ready to supercharge your Excel tasks? Harness the power of Kutools for Excel - your ultimate time-saving tool. Streamline intricate tasks and glide through your data like a pro. Experience Excel at lightning speed! Why You Need Kutools for Excel 🛠️ Over 300 Powerful Features: Kutools is packed with more than 300 advanced features, simplifying your work in over 1500 scenarios. 📈 Superior Data Processing: Merge cells, remove duplicates, and perform advanced data conversions – all without breaking a sweat! ⏱️ Efficient Batch Operations: Why put in extra effort when you can work smart? Import, export, combine, and tweak data in bulk with ease. 📊 Customizable Charts and Reports: Access a broad variety of additional charts and generate insightful reports that tell a story. 🗄️ Powerful Navigation Pane: Gain an advantage with the robust Column Manager, Worksheet Manager, and Custom Favorites. 📝 Seven Types of Drop-down Lists: Make data entry a breeze with drop-down lists of various features and types. 🎓 User-Friendly: A breeze for beginners and a powerful tool for experts. Download Now and Soar Through Time with Excel! Read More... Free Download... Purchase... Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project. Open and create multiple documents in new tabs of the same window, rather than in new windows. Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day! Read More... Free Download... Purchase...


CorelDRAW如何快速替换颜色 CorelDRAW快速替换颜色教程 << 上一篇
2023-10-26 19:10
coreldraw如何打印双面 coreldraw打印双面教程
2023-10-26 19:10
下一篇 >>

相关推荐