I need help with Excel and VBA

Asked By Tyrone E Louis 130 points N/A Posted on - 02/23/2015

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?

• Status: Open
• Question Views: 533
• Answer Count: 0
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel