When you need to apply a small tweak to the document, it should not require much time to Regulate dropdown record. This type of basic activity does not have to require additional education or running through manuals to understand it. Using the proper document modifying instrument, you will not take more time than is necessary for such a swift edit. Use DocHub to simplify your modifying process whether you are a skilled user or if it’s the first time using an online editor service. This tool will require minutes or so to learn how to Regulate dropdown record. The sole thing needed to get more productive with editing is actually a DocHub profile.
A plain document editor like DocHub will help you optimize the amount of time you need to devote to document modifying regardless of your previous knowledge of such resources. Create an account now and increase your productivity immediately 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