The information in this article applies to:
SUMMARYIn Microsoft Excel 2000, it is possible for a Visual Basic for Applications macro to display a UserForm whose name is stored in a variable. This article explains how to do this. MORE INFORMATIONMicrosoft provides programming examples for illustration only, without warranty
either expressed or implied, including, but not limited to, the implied warranties of
merchantability and/or fitness for a particular purpose. This article assumes that you
are familiar with the programming language being demonstrated and the tools used to
create and debug procedures. Microsoft support professionals can help explain the functionality
of a particular procedure, but they will not modify these examples to provide added
functionality or construct procedures to meet your specific needs. If you have limited
programming experience, you may want to contact a Microsoft Certified Solution Provider
or the Microsoft fee-based consulting line at (800) 936-5200. For more information about
Microsoft Certified Solution Providers, please see the following page on the World Wide Web:
http://www.microsoft.com/mcsp/For more information about the support options available from Microsoft, please see the following page on the World Wide Web: http://www.microsoft.com/support/supportnet/overview/overview.aspIn all following examples, the UserForm being used is called "UserForm1". In Microsoft Excel 2000, if you want a Visual Basic macro to display UserForm1, the line of code would be:
Although this syntax is very simple, it can cause problems if you want to
show a UserForm whose name is stored in a variable. For example, if the
variable x contains the name of the UserForm, you cannot simply use the following to display UserForm1.
If you run this macro, you receive the following error message:
UserForm Name Stored in a VariableIf you want to show a UserForm whose name is stored in a variable, use the following code:
User Prompted for UserForm NameYou can use the InputBox method to ask users what UserForm they want to show:
UserForm Name Retrieved from Worksheet CellYou can read a value from a cell in a worksheet:
Prompt for Index Number to Display UserFormYou can include a list of UserForm names in your macro and set the value of x to the UserForm that corresponds to an index number.NOTE: The following example assumes you have three UserForms in your project: UserForm1, UserForm2, and UserForm3. You may want to insert some macro code to make sure the value entered is between 1 and 3, inclusive.
In each case above, the UserForm you want to show must exist. If it does
not exist in your project, you will receive the following error message and your macro will stop.
Additional query words: vbe user form XL2000
Keywords : kberrmsg kbprg kbdta kbdtacode KbVBA |
Last Reviewed: December 13, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |