Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel course tate modern - Excel VBA Forms
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel course tate modern - Excel VBA Forms
Resolved · Low Priority · Version Standard
Reply
Excel VBA Forms
What is the easiest way to go from one form directly into another depending on the result of the first?For upcoming training course dates see: Pricing & availability
RE: Excel VBA Forms
Hi BenI'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
|
 |
|
» Forum post: Macros |
How do I enable Macros?
