using spin buttons to designate column and row
Fertilizer rate is in part determined economically by the cost of fertilizer and the crop prices. The higher the crop prices, the more fertilizer one can afford. The higher the fertilizer price, the less one can afford. This relationship is built into my tables.
I have a small table, about 6 rows by 6 columns. One button (arrow) is used to select a crop price. The other is used to select a fertilizer cost. The table rows are the crop prices and the table columns are the fertilizer costs. How would I code so that the application would select the intersection (cell) designated by the two numbers that provides the fertilizer rate?
I assume that I need to somehow get the macro to know that the one cell is the column heading and the one cell is the row heading and that the designated destination is the table intersection (cell) of these two numbers.