Dropdown list in VBA InputBox

[TimvMechelen]

Hi,

Is it possible to get a dropdown list with VBA InputBox?

The dropdown list has to refer to the table[column]: "TabelMatriaalinformatie[Materiaal:]"

Thank you for you time.

A part of the VBA code i have now:

Dim Materials As Variant

Sheets("Beginblad").Select
Materials = Inputbox("Material:" , "Algemene gegevens product",Range("D13"))
Range("D13").Value = Materials

Now you can put in something manualy.
Can this be a dropdown list?

 

[Norie]

Sorry it's not possible with a built-in InputBox.

However it would be straightforward to create your own 'inputbox' with a dropdown using a userform.

 

[TimvMechelen]

What do you mean with " create your own 'inputbox' "?

 

[Norie]

You could create a userform with a droddown to mimic an inputbox.

 

[TimvMechelen]

You could create a userform with a droddown to mimic an inputbox.

How can i do this?
A dropdown is not necessary, but something sigmilar where i can choose my materials from a list is fine too.


Something like this maybe?

 

[Norie]

Open the VBE (ALT+F11), goto Insert>Userform...

You should now have a blank userform that you can add comboboxes, listboxes, buttons etc.

If you don't want to use a userform you could set up an in-cell dropdown in D13, or any other cell, using Data>Validation... with the List option.

 

[TimvMechelen]

Open the VBE (ALT+F11), goto Insert>Userform...

You should now have a blank userform that you can add comboboxes, listboxes, buttons etc.

How can I do this?

Sorry i'm new to UserForms