can some1 just help me out with this please please pls???

LMF

Board Regular
Joined
Mar 16, 2002
Messages
73
Did you create the ComboBox using View|Toolbars|Forms?

Yes

If so, what is its input range and cell link?

Input range is just saying select list AAA or BBB to be appeared to the list box.

Does the input range of your combobox contain the list names AAA and BBB?

yeah!
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
ok, i got two ranges. named AAA and BBB

in cell A1 i got a number which is either 1 or 2 controlled by a combo box.

i have got a list box that will show list AAA when the number in cell A1 is 1, and show list BBB when the number in cell a1 is 2. how can i do that???

pls help
 
Upvote 0
pls remember that both range AAA and BBB are already using =offset() stuff, so...

pls help!
 
Upvote 0
On 2002-04-14 10:27, LMF wrote:
pls remember that both range AAA and BBB are already using =offset() stuff, so...

pls help!

Did you create the ComboBox using View|Toolbars|Forms?
If so, what is its input range and cell link?

Does the input range of your combobox contain the list names AAA and BBB?

Aladin
 
Upvote 0
Hi,

Oops! I misread your post and started on this with option boxes on the userform. Please change the references to the cell A1 value.

Here, the option box determines which range appears in the ListBox.

Private Sub OptionButton1_Click()
Dim AAAItem, Alist
UserForm1.ListBox1.Clear
Set Alist = Sheets("Sheet1").Range("AAA")
For Each AAAItem In Alist
UserForm1.ListBox1.AddItem AAAItem
Next AAAItem
End Sub

Private Sub OptionButton2_Click()
Dim BBBItem, Blist
UserForm1.ListBox1.Clear
Set Blist = Sheets("Sheet1").Range("BBB")
For Each BBBItem In Blist
UserForm1.ListBox1.AddItem BBBItem
Next BBBItem
End Sub

This should get you started. Please post back if you need more details with your particular setup.

Bye,
Jay
 
Upvote 0
On 2002-01-14 12:33, LMF wrote:
Did you create the ComboBox using View|Toolbars|Forms?

Yes

If so, what is its input range and cell link?

Input range is just saying select list AAA or BBB to be appeared to the list box.

Does the input range of your combobox contain the list names AAA and BBB?

yeah!

I wished I had more specific answers to the above questions. What follows will describe how to connect a combobox with a listbox.

We have a range (preferably in a worksheet called Admin), which is named CList, housing the following items:

AAA
BBB

Again, we have in Admin two ranges which are named AAA and BBB.

In a worksheet, named say Main, create a combobox, using the option View|Toolbars|Forms in B2, with CList as Input range and with B2 as Cell link.

Activate the option Insert|Define|Name.
Enter CurList as name in the Names in Worbook box.
Enter as formula in the Refers to box:

=INDIRECT(INDEX(CList,Admin!$B$2))

Activate OK.

Create a listbox in E2 in Main, using the option View|Toolbars|Forms, with CurList as Input range, with E2 as Cell link, and Selection type set to Single.

That's all.

Aladin
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top