Using buttons in Worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

srinivasanvijay_2000@yahoo.com - 20 Mar 2006 21:21 GMT

Hi,

I have a report to prepare..

Objective is when you click on say button 1 it should show line 6-10
and click on button 2 it should show line 15-20 etc..

Basically they wanted to create you know like have 3-4 buttons and each
one of that have to show some specific lines in the worksheet..

Any help on this would be great guys..

Rgds

Vj

Reply to this Message

jennifer1970@hotmail.com - 20 Mar 2006 22:32 GMT

Private Sub CommandButton1_Click()
Rows("6:10").Select
End Sub

Reply to this Message