[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 main question to the
> roup is this possible.
>
>
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (5)

Recent Activity:

• New Members 4

Visit Your Group

----------------------------------
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

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___