MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

ComboBox Setting

  Asked By: Cameron    Date: Dec 14    Category: MS Office    Views: 643

I would like to now how can I do the following:

I have a workbook with several worksheets (Results, Def01, Def02, Def03 and
Def04), each sheet "Def0X" have in the column B a list of data for witch I
have attribute a range name.

I have made a UserForm to help me inputting data in the worksheet "Results".
In the UserForm I have used some 4 ComboBox to load the lists that are in
the worksheets "Def0X"

My questions are:

1- How can I load the lists in the ComboBox using the range name method?

2- When the data field in the ComboBox don't exist in the list, how can I
update the list automatically by updating the range Name address?



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on ComboBox Setting Or get search suggestion and latest updates.