Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
Sub CreateHyperlinks() Dim s As Shape Dim projectNumber As String projectNumber = "P38947938" Set s = ActiveSheet.Shapes.AddShape(msoShapeRectangle, 50, 50, 50, 25) s.TextFrame.Characters.Text = projectNumber 's.Hyperlink.???? 'TO DO: 'Create hyperlink (using the shape's textframe, possibly) to link to Sheets("data"), 'Then filter Sheets("data") by Project Number. 'ie: Cells("A1") is the Project Number column in Sheets("data"); '''Filter A1 by the given project number passed from the shape's textframe End Sub
|Excel as MS Access front end||11||77|
|Set up conditional formatting so that it goes orange within two cells of a zero entry||4||23|
|Excel 2016 - What is this arrow pointing to a cell?||9||45|
|extract numbers / text from a column||2||28|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!