Excel VBA中的列

Excel VBA中的列 - 属性的矩阵索引无效(Columns in Excel VBA - Invalid matrix index for property)

当我尝试将两列写入单元格A1时出现错误。 什么是错的，我该如何解决它？

Private Sub ComboBox1_DropButtonClick() Sheet1.Range("A1").Value = Me.ComboBox1.Column(0) & " " & Me.ComboBox1.Column(1) End Sub

错误信息

Column属性不能被检索。 属性的矩阵索引无效。

I'm getting an error when I try to write two columns to cell A1. What is wrong and how do I solve it?

Private Sub ComboBox1_DropButtonClick() Sheet1.Range("A1").Value = Me.ComboBox1.Column(0) & " " & Me.ComboBox1.Column(1) End Sub

Error message

The Column property can not be retrieved. Invalid matrix index for property.

最满意答案

那么我认为列计数从1开始不是0 。

因此，您可以使用Me.ComboBox1.Column(1)获取Me.ComboBox1.Value的组合框的值以及该值的右边的值。

Private Sub ComboBox1_Click() Sheet1.Range("A1").Value = Me.ComboBox1.Value & " " & Me.ComboBox1.Column(1) End Sub

在这里查看多栏组合框教程。

Well I think column counting starts with 1 not 0.

So you get the value of the combobox with Me.ComboBox1.Value and the column (right next to the value) with Me.ComboBox1.Column(1).

Private Sub ComboBox1_Click() Sheet1.Range("A1").Value = Me.ComboBox1.Value & " " & Me.ComboBox1.Column(1) End Sub

See here for a tutorial on Multicolumn Combo Box.