When you need to apply a small tweak to the document, it must not take long to Manipulate dropdown diploma. This type of basic activity does not have to demand additional training or running through handbooks to understand it. With the proper document editing instrument, you will not take more time than is necessary for such a quick change. Use DocHub to streamline your editing process regardless if you are an experienced user or if it’s your first time using an online editor service. This tool will take minutes to figure out how to Manipulate dropdown diploma. The sole thing needed to get more productive with editing is actually a DocHub profile.
A simple document editor like DocHub will help you optimize the amount of time you need to spend on document editing irrespective of your previous knowledge of such resources. Create an account now and enhance your productivity instantly with DocHub!
[Music] in this lecture Im going to show you how you can use the combo box form control in your Excel report it basically looks like this so you give the user the option to click on this drop-down and they can select a month from here in this case Im returning the month in two places one is here in an Excel cell and another one is in a text box this looks very similar to the data validation feature in Excel right except that its not the same thing because the data validation feature holds those values in the cell itself in this case its holding it in the combo box object so its separate to the Excel cells Im just going to remove these and were going to do it from scratch also remove this one to insert a combo box you have to go to the Developer tab click on insert and thats the one right here is the combo box and then go anywhere in your excel sheet and just draw it out because Im just going to make it a bit smaller now right mouse click go to format control the main options