Hi everyone,
I'm in the process of trying to suss out userforms.
Senario:
- I've created 3 workbooks to record sales statistics.
- I've got 3 option buttons (which actually work) that puts 0-3 into a cell.
- I need them to allow a user to choose one of the 3 workbooks they want to activate.
- I've got 3 drop-downs (combo-boxes) that lists 5 networks.
- The value that is chosen from the dropdowns will then be used in a find/replace order within the chosen workbook.
- 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
Bookmarks