Please advise what function it is

Question

&nbsp;Saw this in function in the previous file created by my ex-colleague. Apprecite if anyone can advise what is the function and how to create it.&nbsp;&nbsp;Question

detlef_lewin · Answer

MaySeng&nbsp;That is data validation.https://support.microsoft.com/en-us/office/apply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249https://www.contextures.com/xldataval01.html&nbsp;

yea_so · Answer

Hi&nbsp;MaySeng&nbsp;&nbsp;it is called a drop down list.&nbsp; here's a link showing how it is created using the data validation in the toolbar ribbon:&nbsp;https://support.microsoft.com/en-us/office/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b&nbsp;cheers

Forum Discussion

Please advise what function it is

2 Replies

Resources