Re: ComboList Source

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Maybe...

Option Explicit
Private Sub UserForm_Initialize()
dim myArr as Variant
'some test data
myArr = worksheets("sheet999").range("a1:A10").value
'assign the array directly to the list.
Me.Combobox1.List = myArr
End Sub

Mike H. wrote:

I want to set the rowSource Property (The list of the combo box that pops up
when you click the pulldown) to an array that is already built. I try to
type the name of the array in the box but it doesn't allow that. What am I
missing here?
Also, how would the array be set up so that the titles of the columns of
data have a heading?

--

Dave Peterson
.



Relevant Pages

  • Re: incorrect output
    ... And there is no test data to reproduce the wrong output. ... the trajectory travel time calculated ... ("deliver the last entry of the array"), and at some points the array could ... The deeper reason for this is that you declare your variables not at the ...
    (perl.beginners)
  • Re: arithenco Help
    ... You might be right about it having to do with the number of significant numbers in the array. ... I accidentally discovered that if I quantize A and then pass the quantized A with the original 'counts' to arithenco it works perfectly. ... Here's a desciption of it from the help file: ... "The vector counts represents the source's statistics by listing the number of times each symbol of the source's alphabet occurs in a test data set." ...
    (comp.soft-sys.matlab)
  • Re: Shuffle an array of integers.
    ... actually used to generate test data for various sorting algorithms for a ... should be able to adapt this to produce your desired array. ... public int[] generate { ... long sum = 0; ...
    (comp.lang.java.programmer)
  • junit testdata for matrices
    ... double type.I wanted to write some junit testcases for the code. ... returns another 2D array. ... public class MatrixManipulator{ ... I wanted to put all the test data in a single class,say MatrixData, ...
    (comp.lang.java.programmer)
  • Re: remove/replace a harddisk in a unsynced raid1?
    ... >> the array with mdadm. ... The docs say it should work to add raid devices ... Docs for mdadm are still rare and from the manpage ... verify your test data is intact> ...
    (comp.os.linux.misc)