Advertisement
sim156546

Untitled

Oct 29th, 2018
182
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub DropDown2_Change()
  2.  
  3.  
  4. 'putitrng.Rows(1) = ActiveSheet.DropDowns("combobox_test").Value
  5.  
  6. Dim s As Object
  7. Dim ss As String
  8.  
  9. Set s = ActiveSheet.Shapes(Application.Caller)
  10. Set ss = CStr(s.ControlFormat.Value)
  11.  
  12.  
  13.  
  14. ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="444", ScreenTip:= _
  15.         "5435435345", TextToDisplay:=l
  16.  
  17. Stop
  18.  
  19. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement