Reading Values from Excel cell into VB 6 applicati
I have an application that has cascading drop downs. So I have 3 drop downs: Program group, Program, & Department. When a user chooses a Program group, I show a different list of programs for that program gorup. And when a user chooses a Program, I show a different list of departments for that program. When a user chooses a department I attach a costcenter number to it in the background. My problem is that I have hard coded everything. When these program groups, programs, and departments change I have to rewrite the code from scratch. Here is a sample fo my current code:
If (Business_Group.Text = "Finance") Then
If (Department.Text = "Payroll") Then
ElseIf (Department.Text = "Human Resources") Then
ElseIf (Department.Text = "Requisitions") Then
Above, I am attaching the cost center numbers. Is there a way for all the values to just simply read them form an excel spreadsheet? Please help!!!