Google表格 [英] Google sheet

问题描述

 

我想知道我们是否可以制作一个可以带来超链接的下拉列表你到谷歌工作表特定的标签。

解决方案

你好

Hi, 

I would like to know if we can do a dropdown list of a hyperlink that can take you to a tab in specific on google sheet.

解决方案

Hi Bemb11,

You had mentioned that,"I would like to know if we can do a dropdown list of a hyperlink that can take you to a tab in specific on google sheet."

Try to refer example below may help you.

Code:

Private Sub ComboBox1_Change()
    Dim rng As Range
    Dim str As String
        Set rng = Sheets(1).Range("A1")
        str = Me.ComboBox1.Value
            With Worksheets(1)
                .Hyperlinks.Add Anchor:=.Range("A1"), _
                Address:=str, _
                ScreenTip:=str, _
                TextToDisplay:=str
            End With
            rng.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
            rng.Clear
End Sub

Private Sub CommandButton1_Click()
    Me.ComboBox1.AddItem (Me.TextBox1.Value)
End Sub

Private Sub CommandButton2_Click()
    Me.ComboBox1.Clear
End Sub

Output:

Regards

Deepak

这篇关于Google表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！