excel course tate modern - Excel VBA Forms

Resolved · Low Priority · Version Standard

Tue 4 Dec 2007, 15:45 Delegate Ben said...

Ben has attended:
Excel VBA Intro Intermediate course
Access Introduction course

Excel VBA Forms

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

Mon 10 Dec 2007, 09:30 Trainer Carlos said...

RE: 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

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010

When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips

excel course tate modern - Excel VBA Forms

Excel VBA Forms

RE: Excel VBA Forms

Excel articles

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010