如何使用一个旋转按钮更改任意数量的单元格的值？-Howtochangevaluesforanynumberofcellswithonespinbutton?

0  

if your ranges are likely in sequence then you can use the following Function in VBA Editor and save the file as Excel Macro Enabled Workbook in Office-2007-onward versions:

如果您的范围可能是顺序的,那么您可以在VBA编辑器中使用以下功能并将文件保存为Office-2007-sinceward版本中的Excel Macro Enabled Workbook:

Function AutoRange(rngFrom As Range, rngTo As Integer)
    Dim a As Integer
    Dim r As Range
    Dim cell1, cell2, Rng As Range

    Set cell1 = Cells(rngFrom.Row, rngFrom.Column)
    Set cell2 = Cells(rngFrom.Row + rngTo - 1, rngFrom.Column)
    Set Rng = Range(cell1, cell2)

        For Each r In Rng
            a = a + r
        Next
    AutoRange = a
End Function

The function can be used in the format given in following image, i just used 4 cells range here:

该功能可以使用下图中给出的格式,我这里只使用4个单元格范围:

You just have to change green specified Cell value i.e. how much cells are in your Range in sequence downward. If it does not recalculate on changing green cell's value, just press Ctrl+Alt+F9. Just try it, thanks...

您只需更改绿色指定的单元格值,即向下按顺序在您的Range中有多少单元格。如果在更改绿色单元格的值时没有重新计算,只需按Ctrl + Alt + F9即可。试试吧,谢谢......