Bob,
Thanks for the reply. Let me expand on what I am doing. I have a floor plan I made on sheet 1. I want to click on an Table and in a list box, I want all items on that that table to show. The items on the table are on sheet 2. So I have to be able to sort on the living room then that table so I can display all items on the table. My sheet 2 includes all the items in the house with a column for item, room, table, Weight, year bought, and other stuff. so my search needs to be on room and table then for each match i need to list out several columns that are not side by side... Alot huh
-----Original Message-----
Date: Wednesday, February 22, 2012 5:03:14 pm
To: ExcelVBA@yahoogroups.com
From: "Bob" <bob_weller_tx@yahoo.com>
Subject: [ExcelVBA] Re: LISTBOX
If you have a list of items in your work book that you want to show in a list box, then name a range that includes your list. Select the items, right click, Define Name.
In the cell with your list box do the following:
Click the cell you want to have the list box in.
Click on the Data Tab
Click on Data Validation
On the Data Validation Window:
in the Allow box, select List
in the Source Box enter ="Name" where Name is the name you used for the Define Name step.
That will give you a dropdown list in the cell.
--- In ExcelVBA@yahoogroups.com, 1z@... wrote:
>
>
> It's certainly possible to populate a list box with anything you choose... but you need to be able to select items.
>
> Is this a list box on the sheet or a listbox on a user form?
>
> HTH
> Lisa
>
> Sent: Tue, Feb 21, 2012 8:05 pm
> Subject: [ExcelVBA] LISTBOX
>
>
>
> I want a listbox to show items from a spreadsheet. The items have to be certain
> tems so I was thinking a FIND would do the trick. but my m
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar