获取用户选择的范围 [英] Get User Selected Range

问题描述

如何通过用户鼠标输入选择一系列单元格以进一步处理使用VBA？

How can I get a range of cells selected via user mouse input for further processing using VBA?

推荐答案

您可以循环通过Selection对象来查看所选内容。以下是Microsoft的代码片段（http://msdn.microsoft.com/en-us/library/aa203726（office.11​​）.aspx）：

You can loop through the Selection object to see what was selected. Here is a code snippet from Microsoft (http://msdn.microsoft.com/en-us/library/aa203726(office.11).aspx):

Sub Count_Selection()
    Dim cell As Object
    Dim count As Integer
    count = 0
    For Each cell In Selection
        count = count + 1
    Next cell
    MsgBox count & " item(s) selected"
End Sub

这篇关于获取用户选择的范围的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！