Hi everyone,

I'm in the process of trying to suss out userforms.

Senario:
  1. I've created 3 workbooks to record sales statistics.
  2. I've got 3 option buttons (which actually work) that puts 0-3 into a cell.
  3. I need them to allow a user to choose one of the 3 workbooks they want to activate.
  4. I've got 3 drop-downs (combo-boxes) that lists 5 networks.
  5. The value that is chosen from the dropdowns will then be used in a find/replace order within the chosen workbook.
  6. There is also a command button which hopefully will initialise the workbook and the changes to it.

I've done 1, 2 and 4.

But I'm not sure of the next step to tie it all together.

Any advice would be appreciated

Cheers