excel course tate modern - Excel VBA Forms

The UK's most regular instructor-led training courses.
Training information: excel course tate modern · Excel courses · VBA courses London

Resolved · Low Priority · Version Standard

Excel VBA Forms

Ben has attended:
Excel VBA course
Access Introduction course

by - delegate Ben [11 posts] (2007 Dec 4 Tue, 15:45) Reply

What is the easiest way to go from one form directly into another depending on the result of the first?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	3	book now	£475	£495
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	3	book now	£475	£495
2003	2008 Oct 23 Thu + 24 Fri	Southwark	4	book now	£475	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel VBA Forms

by - trainer Carlos gold contributer [413 posts] (2007 Dec 10 Mon, 09:30) Reply

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