SXT Software Exploration Tools programs are also available in a Windows 95 / Windows NT version with graphical user interface (GUI). The functionality of the SXT Windows versions is exactly the same as for the SXT command-line text mode versions, both use the same SXT kerrnel functionality
list box with names from
another sheet and then when the list box changes to activate another
macro that will display some charts.
So far I only have the following code:
Range("B5").Select
A ctiveWorkbook.Names.Add Name:="EmployeeNames", RefersToR1C1:= _
"=Employees!R1C1:R230C1"
A ctiveWorkbook.Names.Add Name:="EmployeeNames", RefersToR1C1:= _
"=Employees!R1C1:R230C1"
W ith Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop,
Operator:= _
xlBetween, Formula1:="=EmployeeNames"
.I gnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
Answered by
Om Prakash
, an ibibo Master,
at
5:44 PM on June 07, 2008