Hi all

Is there a way to get a Drop Down List in the inputbox, so

I can choose from the drop down list
the drop down list has to dapended on another value in A1
i.e if A1=10 then i can choose either 3 or 6 from the drop down lis
that is
placed on the inputbox.........

any soultion or idea is highly appreciated...

Set Bouns Value
BounsV = Application.InputBox("Bouns V IS :", "Set The Bouns Value Fo
This Item", Left:=100, Top:=5, Type:=1)

BounsV = Target.Offset(0, 3).Value

yours :)


--
helmekk

-----------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...nfo&userid=693
View this thread: http://www.excelforum.com/showthread.php?threadid=26628