I have a cell that relates to a lookup table C32 that looks up A62
The lookup table values that appear in cell C32 from time to time need to be overwritten with user-inputted values.
i.e. 5 (from lookup table) to be replaced with say 'Open Class' or whatever, yet still be able to reference the lookup table with future inputs.
Could a Command button function be written to do this in VB and what would that be?
Thanks in advance
Ted
The lookup table values that appear in cell C32 from time to time need to be overwritten with user-inputted values.
i.e. 5 (from lookup table) to be replaced with say 'Open Class' or whatever, yet still be able to reference the lookup table with future inputs.
Could a Command button function be written to do this in VB and what would that be?
Thanks in advance
Ted