can i use drop down list at Form

**shj92922** · 09-23-2018, 04:27 AM

Hello
On data entry i used list for nationality but it doesn't appear on form (Drop down list)
is there is a way to use drop down list at Form without using VBA

FORM.png

Thanks

**Keebellah** · 09-23-2018, 06:01 AM

Not in the way you want it, this form is not programmable
You can however do a lot with validation lists and (dynamic) named ranges.

**shj92922** · 09-23-2018, 07:25 AM

Originally Posted by Keebellah

Not in the way you want it, this form is not programmable
You can however do a lot with validation lists and (dynamic) named ranges.

sad.... thanks for reply

**Keebellah** · 09-23-2018, 07:28 AM

You can always decide on macro's and drop-down lists

**shj92922** · 09-23-2018, 09:48 AM

Originally Posted by Keebellah

You can always decide on macro's and drop-down lists

so any helpful suggestions or ideas

**Keebellah** · 09-23-2018, 05:08 PM

I don't know what the requirements are and what you need at the end.

So a clear and concise explanation will help and if you want it without VBA, well, that will take some thinking and deciding how to approach it.

Something like creating a table and where you require picklists place data validation lists