I have a combobox on a sheet that I need to assign values (say from 200, 210,
220...300) and when you choose a value from it, it multiplies that value with
the value from a cell. I have tried loading these values with the on activate
and worksheet open etc, but I couldn't get it to load values until I assigned
the input range. Now it loads the values, but I have the text on the sheet
(hidden by matching text color with cell background color) and I would like
to not go that route if possible. Anyway, I created a new macro to multiply:
Sheet2.Range("T44").Value = Sheet2.Range("r44").Value * Sheet2combo.text -
but it doesn't work..

Can someone help? Thanks!