Help needed in Excel
06 June 2003, 11:55 AM
#2
Scooby Regular
Join Date: Jul 2001
Location: deep inside your imagination
Posts: 24,057
Likes: 0
Received 0 Likes
on
0 Posts
Wasn't aware you could do that in Excel - I know you can in Word (using forms) or Access.
Will watch this thread with interest, might learn something.
Will watch this thread with interest, might learn something.
06 June 2003, 12:07 PM
#3
Scooby Regular
Join Date: Sep 2002
Location: Essexville
Posts: 4,391
Likes: 0
Received 0 Likes
on
0 Posts
like this???
BB
bring up the forms toolbar, and away you go mate.....
drag out a combobox, enter a range
bingo...
BB
[Edited by beemerboy - 6/6/2003 12:09:32 PM]
06 June 2003, 12:08 PM
#4
Scooby Regular
Join Date: May 2003
Posts: 1,165
Likes: 0
Received 0 Likes
on
0 Posts
Ohhh
found this havent tried it yet on excel v2002
In the Allow box, click List.
Click the Source box and then do one of the following:
To define the list locally, type the list values separated by commas.
To use a range of cells with a defined name, type the equal sign (=) followed by the name of the range.
To use cell references, select the cells on the worksheet and then press ENTER.
Make sure the In-cell dropdown check box is selected.
found this havent tried it yet on excel v2002
In the Allow box, click List.
Click the Source box and then do one of the following:
To define the list locally, type the list values separated by commas.
To use a range of cells with a defined name, type the equal sign (=) followed by the name of the range.
To use cell references, select the cells on the worksheet and then press ENTER.
Make sure the In-cell dropdown check box is selected.
06 June 2003, 12:11 PM
#5
Moderator
iTrader: (5)
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes
on
0 Posts
You can use the Forms toolbar and the List or Combo box.
You can also do Right-click, Pick From List as well if the values already appear in that column.
You can also do Right-click, Pick From List as well if the values already appear in that column.
Trending Topics
Thread
Thread Starter
Forum
Replies
Last Post
robbie1988
Wanted
2
13 September 2015 09:25 AM
Scooby-Doo 2
Wheels And Tyres For Sale
1
09 September 2015 06:51 PM