Populating work sheet combox with another work sheet values

S

sjayar

Hi All,

I have a combox in my sheet(1) which i want to populate with values
present in sheet(2).

I can populate combox in sheet(1) by setting the
"ListFillrange"property to the required ranges in the sheet(1)
(assume in coulmn A i have values from A1: A5)

But i am unable to populate same combox with sheet(2) values(assume in
sheet(2) C column i have set of values from C1: C10).

I want to populate without using any macros.

Can anyone Please help me to solve this problem

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto populate value from one task to another in MS PROJECT 0
Combo boxes in excel 6
Using Drop Down list to an If Statement to another Drop Down list 3
combo box 2
Auto populate from list on separate sheet 3
Filter a combox based on selection from another combox 2
V Lookup multiple entires 1
Macro to add new sheet and then fill formula in a totals sheet to refernce this sheet 1

Top