User Profile
TomasCiganek
Copper Contributor
Joined Apr 07, 2020
User Widgets
Recent Discussions
Re: Dynamic links creation
Hi, SnowMan55 Thanks for the guidance, my simplified solution which works looks like: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 14 Then 'Reacts to changes only in defined column Set ChangedCell = Cells(Target.Row, Target.Column) ChangedValue = ChangedCell.Value ' Get a new value Address = Cells(WorksheetFunction.Match(ChangedValue, Worksheets("Deliverables").Range("A1:A30"), 0), 1).Address 'Find a cell address of the selected value in other sheet ActiveSheet.Hyperlinks.add Range(ChangedCell.Address), Address:="", SubAddress:="Deliverables!" & Address, TextToDisplay:=ChangedValue 'Add a new hyperlink End If End Sub1.2KViews1like0CommentsDynamic links creation
Hi, Is there any way (even via VBA script) how to do this: 1. Having a column where cell values can be selected only using a pre-defined drop-down list (data source is on a different sheet) 2. I need to create a link on that original data source cell Example: Sheet2 contains A1-Apple, A2-Orange, A3-Peach In Sheet1 column A I need to be able to select only Apple, Orange or Peach and based on my selection I need to have also a hyperlink on that cell which will lead to the selected item on Sheet2 (so if for Sheet1!A1 I choose Peach from drop-down, I need to see the Peach in the cell and have a link to Sheet2!A3) I've tried something already but I got a "circular reference error" 😞 ThanksSolved1.4KViews0likes3Comments
Recent Blog Articles
No content to show