Sub control() ' Macro recorded 2/7/2006 by Hana Lee ' DECIDE WHICH FORMAT TO USE Dim arraytype arraytype = _ Application.InputBox(Prompt:="What type of array format are you using? (Answer 2 or 16).", _ Title:="Two replicates or multiwell format", Type:=1) Select Case arraytype Case 2 Call twoarray Case 16 Call multiwell Case Else Exit Sub End Select End Sub