Including record formats into modules

[jhoward0101]

Hello,
I'm looking for the best way to manage a group of data record layouts where I can create one module with these record layouts, (all DIM names and types), and include them into worksheets with 30 separate code modules.
I would like to modify the record layouts in one place, and have all modules in all worksheets use the same record layout.
Is this possible in VBA?
Thanks, in advance, for any help with this.
James Howard

 

[Norie]

James

What do you mean by a 'record layout'?

 

[jhoward0101]

James

What do you mean by a 'record layout'?

Might be a little old school, but I define each cell in a row with a variable name and type. Have several sheets where cell in a row have a name and variable type, such as CallPrice, CallExpireDT, CallTicker, etc. I continually add new variables to these rows and want to create a layout for the row, and have all modules that reference the data use the same layout and cell name.

Hope that makes sense.

Thanks

 

[Norie]

Couldn't you use named ranges or headers to identify each column?

 

[jhoward0101]

How would I use headers so that all modules could refer to them. When changing the headers, all macros have the change?
Thanks