| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I add scrollbar to a number of cells
Assumed is that the scrollbar is named "ScrollBar1". In the worksheet's code
module paste this: Private Sub ScrollBar1_Change() Range("A45:A105").Value = ScrollBar1.Value End Sub To access the worksheet's code module, right click the worksheet tab and select View Code. Then paste the above. Regards, Greg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Number Within Range Then Copying Data Below Number to Cells | Excel Programming | |||
| Count number of times a specific number is displayed in cells | Excel Programming | |||
| scrollbar reslut makes another scrollbar to show | Excel Discussion (Misc queries) | |||
| excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
| Scrollbar | Excel Programming | |||
Hybrid Mode
