Hi,

I have an excel spreadsheet (windows 2000) where i wish to prompt the user to enter data in an input box based on the selection they have chosen from a combobox

eg. When they select "Quarterly" from the combobox i want an input box to appear asking them "which month?" I have written the code based on the cell link value but this does not work

Sub test()
If Range("g4")...