populate comboboxes with two named range from

April 24, 2011 at 02:51:35
Specs: Windows XP
I had a workbook(named jaison) with three worksheets (named paid & customers & data).In it i created a NameRange (custID) in sheet paid and Name Range (Location) in sheet customers.i want to creat a userform (named UF1) with two combo boxes named (CBO1 & CBO2). CBO1 filled values from NameRange custID (sheet 'paid') and CBO2 filled values from NameRange Location (sheet 'Customers').i want to enter userform(UF1) value to sheet 'data'. Please help me

See More: populate comboboxes with two named range from

May 27, 2011 at 04:36:55
Here try this, enter the following in cells A1 to A4

A1: This
A2: Is
A3: A
A4: Test

select these cells and call this range test

now add your combox and a button on your userform and add the following code to the buttons click event

Private Sub CommandButton1_Click()

Dim Bcell As Range

For Each Bcell In Sheet1.Range("test")

ComboBox1.AddItem Bcell.Value

Next Bcell

End Sub

Report •
Related Solutions

Ask Question