Click Developer > Insert > Combo Box, and drag the cursor to draw a combo box as you need. Second, create a combo box and format the control.Ģ. Give your hyperlinks list a range name “ Hyperlinks”, and name a blank cell “ Linked_cell” which is the linked cell of the combo box value into the Name Box, see screenshots: Please do as follows:įirst, please create two range names for your hyperlinks list and a linked cell.ġ. There is no direct way to create drop down list with activated hyperlinks in Excel, but, you can insert a formula to activate the selected hyperlink from the drop down list, please do as this:Īfter creating the drop down list, please enter this formula: =HYPERLINK(D2,"Go To Website!") ( D2 is the drop down list cell) in cell E2 which beside your drop down list cell, and press Enter key, then when you choose one URL hyperlink from the drop down list, and click the formula cell, the hyperlink will be opened.Īctually, you can also create a drop down list with hyperlinks by using combo box, and when you select a hyperlink from the combo box, it will be activated at once. In Excel, adding drop down list may help us to solve our work efficiently and easily, but, have you ever tried to create drop down list with hyperlinks, when you choose the URL address from the drop down list, it will be open the hyperlink automatically? This article, I will talk about how to create drop down list with activated hyperlinks in Excel.Ĭreate drop down list with hyperlinks by using formulaĬreate drop down list with hyperlinks by using combo box
If you see any error message, update it with the name of newly added dropdown control name.How to create drop down list with hyperlinks in Excel? change the Y-axis property of ErrorMessage name of old DatacardValue into the new Dropdown control name.like: Y= Dropdown1.Y + Dropdown1.Height.ħ. ErrorMessage of that Datacard may so error. If you hide the text input datacard, this step is not required. Change Update property of the datacard : Update = where Dropdown1 is tha name of newly added dropdown control.Ħ. Change new dropdown's property Items as array of your options : Items = ĥ. Insert New dropdown control inside that datacard.Ĥ. Delete the DataCardValue (Input control) of that Datacard.
In advanced properties, unlock to change properties.Ģ. Select the Datacard for the field you want to make dropdown. I assume you are trying to add new record where one of the field is dropdown but that field is not dropdown in the excel.ġ. Hi you explain in details about your scenario?
0 kommentar(er)
