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

Create a userform with a combobox.

--

HTH

RP

"helmekki" wrote in message
...

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 list
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 For
This Item", Left:=100, Top:=5, Type:=1)

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

yours :)
h


--
helmekki


------------------------------------------------------------------------
helmekki's Profile:
http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=266280