| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using buttons in Worksheet
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using buttons in Worksheet
Private Sub CommandButton1_Click()
Rows("6:10").Select End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating buttons in worksheet | Excel Discussion (Misc queries) | |||
| 'Save current worksheet'; 'Open next worksheet' - two command buttons | Excel Discussion (Misc queries) | |||
| Adding Buttons to Worksheet | Excel Programming | |||
| Option buttons on a worksheet | Excel Discussion (Misc queries) | |||
| Can I use more than one set of option buttons in a worksheet? | Excel Worksheet Functions | |||
Linear Mode
