They're just hints as to what you might want to enter, referring to ro
and column arguments.
Just a plain cutn'n'paste from the help files:
*********************************
Column Property
Specifies one or more items in a ListBox or ComboBox.
Syntax
object.Column( column, row ) [= Variant]
The Column property syntax has these parts:
Part Description
object Required. A valid object.
*column* Optional. An integer with a range from 0 to one less than th
total number of columns.
*row* Optional. An integer with a range from 0 to one less than th
total number of rows.
Variant Optional. Specifies a single value, a column of values, or
two-dimensional array to load into a ListBox or ComboBox.
Settings
If you specify both the column and row values, Column reads or writes
specific item.
If you specify only the column value, the Column property reads o
writes the specified column in the current row of the object. Fo
example, MyListBox.Column (3) reads or writes the third column i
MyListBox.
Column returns a Variant from the cursor. When a built-in curso
provides the value for Variant (such as when using the AddItem method)
the value is a string. When an external cursor provides the value fo
Variant, formatting associated with the data is not included in th
Variant.
Remarks
You can use Column to assign the contents of a combo box or list box t
another control, such as a text box. For example, you can set th
ControlSource property of a text box to the value in the second colum
of a list box.
If the user makes no selection when you refer to a column in a comb
box or list box, the Column setting is Null. You can check for thi
condition by using the IsNull function.
You can also use Column to copy an entire two-dimensional array o
values to a control. This syntax lets you quickly load a list of choice
rather than individually loading each element of the list usin
AddItem.
Note
When copying data from a two-dimensional array, Column transposes th
contents of the array in the control so that the contents o
ListBox1.Column(X, Y) is the same as MyArray(Y, X). You can also us
List to copy an array without transposing it.
neal;575736 said:
Dim searchRow As Integer
Dim searchCol As Integer
searchRow = 12
searchCol = miscCol
While (Cells(searchRow, searchCol) <> "")
UserForm1.ListBox1.ColumnCount = 2
UserForm1.ListBox1.AddItem Cells(searchRow, searchCol)
UserForm1.ListBox1.Column (
when I start typing this in, a box appears by my typer icon, saying
need
to add ([pvargColumn), pvargIndex)) or something like that. An
ideas?
I've never used this function or method before.
thanks
