Re: ComboList Source
- From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
- Date: Mon, 06 Aug 2007 13:29:37 -0500
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
.
- Prev by Date: Re: Convert Named Ranges to Addresses
- Next by Date: Re: How to Create Main Macro File
- Previous by thread: Re: Autonew
- Next by thread: Re: ComboList Source
- Index(es):
