View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Fire event code with Hyperlink and copy/paste RadioButtons

2-part question:
#1) How do I fire event code by clicking a hyperlink? I dont want to go
to a web site; just want to run a macro. Im just looking for a way to click
a hyperlink and fire some code. Spent a bit of time searching online for a
solution but didnt see anything.
#2) How do I copy/paste objects, such as radio buttons and some check
boxes, from a row above my active row, insert a row, and paste the objects
there?

Heres the code that Im fiddling with now:
Private Sub worksheet_selectionChange(ByVal Target As Range)
If Target.Address = "$A$15" Then
ActiveCell.Offset(1, 0).EntireRow.Insert
ActiveCell.Offset(-1, 0).EntireRow.Copy
Rows(ActiveCell.Row).PasteSpecial
End If
End Sub

The Hyperlink part isnt working and the copy/paste objects part isnt
working.
Appreciate any help with this!
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.