excel - Create drop down list in input-box -

excel - Create drop down list in input-box -

i'm creating task list our team, , come in new tasks i've created input-boxes. there 5 departments should entered in "department question" te prevent people entering wrong section name, utilize input-box drop downwards list.

i've searched net, not find how create drop downwards list in input-box. don't know if possible?

can help me?

the code wrote inputs followed:

private sub newaction_click() dim content string, date1 date, date2 date, section string sheets("do not delete").rows("30:30").copy rows("14:14").select range("c14").activate selection.insert shift:=xldown content = inputbox("describe task") range("c14").value = content section = inputbox("to section task assigned? ") '<-- here want create drop downwards list range("d14").value = section date1 = inputbox("when task start") range("f14").value = date1 date2 = inputbox("when should task finished? ") range("g14").value = date2 end sub

i have created form in excel in stead of using input box. selection of section created combo-box right departments:

private sub newaction_click() sheets("do not delete").rows("30:30").copy rows("14:14").select range("c14").activate selection.insert shift:=xldown cells(14, 3) = taskd.value cells(14, 5) = combobox1 unload me userform2.show end sub private sub userform_initialize() taskd.value = "" combobox1 .additem "lean" .additem "maintenance" .additem "process engineering" .additem "safety" .additem "workinstructions" end end sub

for dates created separate form (userfrom2 , userform3) come in dates on calander.

private sub monthview1_dateclick(byval dateclicked date) on error resume next startd = dateclicked cells(14, 6).value = startd unload me userform3.show end sub private sub monthview1_dateclick(byval dateclicked date) on error resume next endd = dateclicked cells(14, 7).value = endd unload me end sub

the monthview1 alternative in excel can activate via: forms toolbox --> right click on toolbox --> select additional controls --> microsoft monthviews control

excel vba