Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 24-06-2009
Member
 
Join Date: Jun 2009
Posts: 441
Use userform vba using Excel

As everyone knows Excel is the King in the corporate world, I working on Excel for my office purpose. I want to create a userform and define it using VBA coding. Can I do so? If yes, then how to create a userform using Excel VBA coding?
Reply With Quote
  #2  
Old 25-06-2009
XSI XSI is offline
Member
 
Join Date: May 2008
Posts: 271
Re: Use userform vba using Excel

The syntax that is used to display a UserForm programmatically:

Code:
UserFormName.Show
You can load a UserForm into memory without actually displaying it. It may take a complex UserForm several seconds to appear. Because you can preload a UserForm into memory, you can decide when to incur this overhead. To load UserForm into memory without displaying it, use:

Code:
Load UserForm
To remove a UserForm from memory, use the Unload statement.

Code:
Unload UserForm
Reply With Quote
  #3  
Old 25-06-2009
Member
 
Join Date: Nov 2008
Posts: 1,221
Re: Use userform vba using Excel

To create a new UserForm

1. Open the Excel workbook and go to VBA (ALT + F11).
2. Under VBA, click the "Insert UserForm" button.
3. Click Toolbox button.
4. Use controls on the form by clicking the appropriate button on the toolbox.
5. To edit the properties of a control, use the Properties window.
6. To remove a control, select and press the Delete button.
Reply With Quote
  #4  
Old 25-06-2009
Member
 
Join Date: May 2008
Posts: 945
Re: Use userform vba using Excel

In Excel you can use lots of ActiveX controls in a UserForm:
  • Label control
  • TextBox control
  • CommandButton control
  • ListBox control
  • ComboBox control
  • Frame control
  • OptionButton control
  • CheckBox control
  • ToggleButton control
  • TabStrip control
  • MultiPage control
  • ScrollBar control
  • SpinButton control
  • RefEdit control
  • Image control

A complete list of all the properties and methods for a specific command is available in the Object Browser. To find this information in Excel, follow these steps:
  1. On the Tools menu, point to Macro, and then click Visual Basic Editor.
  2. On the View menu, click Object Browser.
  3. In the Search Text box, type the name of the control that you want, and then click Search.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Use userform vba using Excel"
Thread Thread Starter Forum Replies Last Post
crystal reports connection to excel vba userform shankar.nstl Software Development 1 01-10-2011 03:44 PM
Excel/VBA: Copying text from UserForm Textbox to a Worksheet Textbox Neil Ives Software Development 2 20-08-2010 01:23 AM
Excel VBA Code For Minimizing UserForm warehouse peon Software Development 4 25-01-2010 08:45 PM
How to display an image in a Userform on setting the path ANSEL Software Development 3 26-10-2009 11:46 PM
Resize userform Window Clemens Software Development 2 16-04-2009 07:55 PM


All times are GMT +5.5. The time now is 03:13 AM.