is Select Case best way of doing this

[Kavy]

Good day,

Its been a long time since I have last posted, I have missed this forum!

Anyway,

I have to populate a cell with different types of data, based on the code is in an adjacent cell. For example if the code in the adjacent cell reads "GL", I then have to populate the cell with the "owners name" the "size", other codes require different variables.

All the information needed for each variable (i.e. owners name) is on the same line as the cell I am trying to populate.

I am trying to think of the best way to do this, there are about 33 codes, each with different variable requirements, some requiring up to 8 different variables.

I was going to use a "Select Case" method, where it sees the code, it then selects that case, and with in the code it steals the variable data from the proper cells.

Another method I was going to use, was what I just mentioned, but have a second select case for the variables, instead of if statements.

Thank you for any tips!!

Kavy

 

[Jerry Sullivan]

Hi Kavy,

Perhaps your system would be easier to maintain if you created a table in your workbook with a field for the code and another 7-10 fields for the variables that you want to place when that code is selected.

Your VBA code could then lookup the list of variables in your table instead of with the Select...Case statement.

You could do what you describe using Select...Case; however that means you need to edit your VBA code each time you add codes or make revisions.

 

[Norie]

Why a second select case?

What do all the Ifs do?