Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Excel - List Box

Thread Tools
 
Search this Thread
 
Old 05 July 2004, 09:22 PM
  #1  
velohead66
Scooby Regular
Thread Starter
 
velohead66's Avatar
 
Join Date: Oct 2002
Location: ex UK [SE], now Sunshine State [QLD,AUS]
Posts: 565
Likes: 0
Received 1 Like on 1 Post
Question Excel - List Box

I want a user to have a choice of three inputs only, to populate a cell.
Choices are [feet] [yards] [metres]

I beleive that I can do this using a "list box".

OK, but how ???
Old 06 July 2004, 08:27 AM
  #2  
Fosters
Scooby Regular
 
Fosters's Avatar
 
Join Date: Jul 2000
Location: Islington
Posts: 2,145
Likes: 0
Received 0 Likes on 0 Posts
Default

select the cell, go to Data, validation, select list. enter your values comma separated or select a range.

that's it.
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
has-scooby
Subaru Parts
4
06 October 2015 03:47 PM
Ganz1983
Subaru
5
02 October 2015 09:22 AM
the shreksta
Other Marques
26
01 October 2015 02:30 PM



Quick Reply: Excel - List Box



All times are GMT +1. The time now is 10:41 AM.