Print Signed Dropdown with airSlate SignNow

Copy dropdown charter

in this video I'll show you how to run a macro from a drop-down list and actually it depends on the value you selected so if you select the first value in a drop-down list the specific macro is RAM and if you select the second one another macro is roaming the first thing to do is to create a drop-down list so select a cell and go to tab data on the ribbon [Music] and their slick data validation button and here click this drop-down list and select list and here you have the source values and I'm going to use quadrant 1 comma micro to click OK and now we have a drop-down list in cell b2 and if you click on this you are now able to select a text string and that texturing shows up in the cell to be able to run a macro you we need to add event code to this workbook and to do that you can right-click on the sheet you want event code to be and then click view code and this opens the baby editor visual basic editor and you can see that G 2 is selected here and this is the code module for G 2 and here place the code here go back to my website and find the event code copy it and then go to the VBA editor and paste it here the worksheet change code here allows you to monitor a sheet and if a cell value has changed the target parameter here changes to that cell and the code in here is run and the next line here checks if cell b2 has changed and if it has it goes on to the next line if it hasn't changed it goes down here and ends and this line here checks the value in cell b2 and if it is macro 1 it runs this macro and if the text string in cell b2 is macro two it runs this macro to add a macro to you workbook right click on your workbook here and then click insert and module and this as a code module 2 workbook and here type the macro you want to use and the first macro is going to show a message box with the value macro 1 and the second macro is going to be my foot too and it will show messagebox macro too so if I now change the value here and then drop down list to macro well I get an error here and that is because I have the same name on both micros and let's try this again macro - and now it runs micro - and a message box appears with their value macro - and if I change this to metal one this macro here is executed and it shows macro one and if you change a value in another cell on this sheet nothing should happen because this event code...