A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Filling drop down box



 
 
Thread Tools Display Modes
  #1  
Old November 25th, 2004, 08:37 AM
external usenet poster
 
Posts: n/a
Default Filling drop down box

hi,

I have a drop down box in a cell. Based on a value of
anohter cell I have to fill my drop down box. what i mean
is, say if
GreeNPackage is "No" then I want the drop down box to fill
a range of values. But if the GreeNPackage is "Yes" then I
want the drop down box to fill another set of values. how
can i do this?

plenty of thanks

  #2  
Old November 25th, 2004, 09:31 AM
Biff
external usenet poster
 
Posts: n/a
Default

Hi!

In the data validation, allow list source box, you can
enter a formula to test for YES or NO:

=IF(E1="YES",F1:F10,G1:G10)

How it works:

If cell E1=YES use the values in F1:F10 as the source for
the dropdown, otherwise, use G1:G10 as the source.

Biff

-----Original Message-----
hi,

I have a drop down box in a cell. Based on a value of
anohter cell I have to fill my drop down box. what i mean
is, say if
GreeNPackage is "No" then I want the drop down box to

fill
a range of values. But if the GreeNPackage is "Yes" then

I
want the drop down box to fill another set of values. how
can i do this?

plenty of thanks

.

  #3  
Old November 25th, 2004, 08:49 PM
Nick
external usenet poster
 
Posts: n/a
Default

Instead of drop down you can use data validation list and create to
set of range names:

First will have value yes and no and then we will have to create to
other ranged names, named yes and no. in those ranges you keep your
parameters that you want to show as option to users.

Then in the cells where you want to have yes/no answer you set data
validation to you Ye/no named range. Then in the cell where you want
to show values for yes or no, you set data validation to
=(indirect([Address of yes/no cell]). So when the user is selecting
let's say yes, the list validation will be set by indirect to named
range yes.

This method will avoid writing any VB code..

If any questions, contact me.

Regards,

Nick


wrote in message ...
hi,

I have a drop down box in a cell. Based on a value of
anohter cell I have to fill my drop down box. what i mean
is, say if
GreeNPackage is "No" then I want the drop down box to fill
a range of values. But if the GreeNPackage is "Yes" then I
want the drop down box to fill another set of values. how
can i do this?

plenty of thanks

  #4  
Old November 26th, 2004, 01:54 AM
external usenet poster
 
Posts: n/a
Default

hey thanks nick..

it works :-)
gr8!
-----Original Message-----
Instead of drop down you can use data validation list and

create to
set of range names:

First will have value yes and no and then we will have to

create to
other ranged names, named yes and no. in those ranges you

keep your
parameters that you want to show as option to users.

Then in the cells where you want to have yes/no answer

you set data
validation to you Ye/no named range. Then in the cell

where you want
to show values for yes or no, you set data validation to
=(indirect([Address of yes/no cell]). So when the user is

selecting
let's say yes, the list validation will be set by

indirect to named
range yes.

This method will avoid writing any VB code..

If any questions, contact me.

Regards,

Nick


wrote in message

...
hi,

I have a drop down box in a cell. Based on a value of
anohter cell I have to fill my drop down box. what i

mean
is, say if
GreeNPackage is "No" then I want the drop down box to

fill
a range of values. But if the GreeNPackage is "Yes"

then I
want the drop down box to fill another set of values.

how
can i do this?

plenty of thanks

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop down problems Guernsey Gaz Using Forms 0 November 17th, 2004 05:06 PM
Linking drop down boxes zaika General Discussion 2 October 30th, 2004 04:42 PM
Drop downs Neil R General Discussion 2 June 16th, 2004 12:00 AM
Values in drop down box dynamic Chris Worksheet Functions 1 May 8th, 2004 07:25 AM
Drop drow box - Help! Crystal Worksheet Functions 4 January 23rd, 2004 08:50 PM


All times are GMT +1. The time now is 01:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.