I need help with Excel and VBA
I have created a form in Excel and labeled it ‘Form 1’. This form is to act as a command button, in that whenever it is clicked, it leads to a different spreadsheet. The data in form 1 is placed in a combo box, hence it varies according to what a user picks. I need a code that would enable the command button choose a spreadsheet to open when a value is chosen. Any help?