When you want to apply a minor tweak to the document, it must not take long to Shape dropdown record. Such a basic activity does not have to require extra education or running through handbooks to learn it. With the proper document modifying resource, you will not spend more time than is necessary for such a swift edit. Use DocHub to streamline your modifying process whether you are a skilled user or if it is the first time making use of an online editor service. This instrument will require minutes to figure out how to Shape dropdown record. The only thing needed to get more effective with editing is actually a DocHub profile.
A plain document editor like DocHub can help you optimize the amount of time you need to devote to document modifying regardless of your previous experience with such tools. Create an account now and improve your efficiency 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