Row and reference of a button

**NoMorePeas** · 02-09-2009, 08:02 PM

I have scanned the forum and cannot seem to get a simple answer on how to do this, sorry i am only a newbie programmer.

I have a button that when pressed i would like to perform serveral actions based on the reference of the button. How can i get this?

Ultimately when the button is pressed i would like to insert a row where the button is located, copy cells along this row, and delete rows relative to this button.

Thanks in advance for your help.

**mrice** · 02-10-2009, 05:22 AM

One way to do this is to add a comment to the cell in which the button sits and have the name of the button as the comment text.

e.g.

Sub Button1_Click()
Cells.Find(Sheet1.Shapes(1).Name, , xlComments, xlWhole).Insert
End Sub

and the comment is Button 1

**Andy Pope** · 02-10-2009, 05:34 AM

Some previous posts on similar topic

http://www.excelforum.com/excel-prog...-the-code.html
http://www.excelforum.com/excel-prog...elete-row.html

Row and reference of a button

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Row and reference of a button

Re: Row and reference of a button

Re: Row and reference of a button

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions