excel course tate modern - Excel VBA Forms

Hi Ben

I'm taking your question to mean if you select a particualr value in the first for and this dictates which new for to open.

With this in mind lets suppose you have a combobox cboSelect on frmStartForm and frmX and frmY

On the OK button of frmStartForm place the following code:

If cboSelect.Value = "Form X" then
frmX.show
Else
frmY.Show
End if

Hope this helps

Carlos