LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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''.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use Scheuled Tasks to fire Event Code ryguy7272 Excel Programming 2 December 7th 09 11:11 PM
Event drivin copy and paste code GoBucks[_2_] Excel Programming 7 May 7th 09 03:04 PM
Copy Sheet causes Combo Box change event to fire on original sheet AJ Master Excel Programming 0 November 10th 08 07:49 PM
event fire Curt Excel Programming 19 March 7th 07 12:29 AM
Event doesn't fire Frank Xia Excel Discussion (Misc queries) 6 February 11th 06 12:54 AM


All times are GMT +1. The time now is 06:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"