IF function and combo boxes

M

Mark Dullingham

Could some one please help!
Is it possible to display a combo box when an IF funtion returns as false?
 
N

NAVEEN

Hi,

Sorry!
Question is not clear. Could you re-send the question clearly.

Regards,
NAVEEN
 
P

paul

the combo box disapearing act would have to vba driven....you could blank out
the values in the combo box tho.....
 
M

Mark Dullingham

Sorry for the rubbish question.
I've been having a think and what I really want to do is as follows-

I have an array with customer names and service contract numbers and use
VLOOKUP when a customers name is selected from a combo box to auto fill the
contract number.
What I would like is if the vlookup does not return a value (not all names
have a service numbers the a combo box appears with 2 choices Project or
Extra. When the choice has been made from that box another appears with a
list of standard numbers we use for either projects or extra works. The user
then makes their selection and the value is entered into the active cell
maintaining the vlookup formula.
Currently the user just over types their required number and the fromula is
lost.

I know depandant DV would seem the way to go but I am using combo boxes that
pop up when a certain cells are selected. this way I only have 4 combo boxes
that can be used to fill any 1 of about 500 cells. So to add this
functionality in this way would only require 3 more combo's Oh and the code
of course which is where I come a bit unstuck!!!!

Is it possible to change the named list a combo uses based on its selection?
if so this would mean only adding 1 more box and changing its fill range.

Any suggestions on this will be received with many thanks so in advance----

Thanks
 
Top