![]() Step6: close the current Visual Basic Editor window, and you can try to select TRUE or FALSE item from the drop down list box, and you should see that the column B or Column C is hidden or unhidden. ![]() ( ' move ' ' Moves SAS members from the source library to the target library and deletes the original members from the source library. Note: the $A1$2 is the Cell Reference of the drop down list in your worksheet. (' slibref ' ' (library) Specifies a libref that is assigned through a SAS/SHARE or SAS/CONNECT server to use for migrating catalogs. Private Sub Worksheet_Change(ByVal Target As Range) Step5: paste the below VBA code into the code window. JSL Expressions What exactly is a JSL expression Chapter 3 of the JMP Scripting Guide (JSG) defines JSL expressions thus: A JSL expression is any combination of variables, constants, and functions linked by operators that can be evaluated. Step4: Double click on the current sheet name in the VBAProject section to open the code window. JSL expression handling functions and show how such functions can be used to solve nontrivial JSL programming challenges. Step3: then the “ Visual Basic Editor” window will appear. Step2: open your excel workbook and then click on “ Visual Basic” command under DEVELOPER Tab, or just press “ ALT+F11” shortcut. (just go to DATA tab, click Data Validation command, then you create a drop-down list in Cell A2) Step1: you need to create you drop-down list with TRUE and FALSE items in Cell A2.
0 Comments
Leave a Reply. |