Drop Down List in Inputbox

  • Thread starter Thread starter helmekki
  • Start date Start date
H

helmekki

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 :)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to dynamically change the list in drop down list based on thevalue of another cell? 1
Inputbox with a drop down? 2
Data Validation List (conditional) 2
Clear a "moving" range offset from Target 31
Pick from drop-down list gives empty or erroneous result 6
Combine three InputBoxes into one? 7
Multiple entries from a drop down list 1
EXCEL DROP DOWN 2

Back
Top