Geek asks and answers

What form controls can access a VBA project from Office 2007?

In a VBA project, you can create a UserForm and add controls to it using the toolbar window. By default, the toolbar window contains simple form elements such as Label, TextBox, ListBox, etc.

You can add additional controls if they are installed on your computer: right-clicking on the “additional controls” in the toolbar displays a whole panel of controls. However, this does not give any indication of where they came from.

I’m interested in knowing which controls are guaranteed to be available on the computer on which Office 2007 is installed. Are they standard, or are some of the “optional controls” also guaranteed to be available (either because they come with Office 2007, or because Do they exist in all versions of Windows that Office 2007 will run)?

For example, I am surprised that Office 2007 does not have a TreeView control. On my list of “additional controls” I see “Microsoft TreeView Control v6,” but I don’t know if I can rely on this for all of my 2007 Office users.

+5
source share
1 answer

, , FM20.DLL; Office Install.

, DLL, "" " ".

enter image description here

AFAIK, , Office.

, , , :

  • "grid"

, . VBA , make Grid-like.

, , Excel :

ID001   Value 1 Description 1
ID002   Value 2 Description 2
ID003   Value 3 Description 3

, , listbox ColumnCount 3 :

    Me.ListBox1.ColumnWidths = "50;100;200"
    Me.ListBox1.RowSource = Sheet1.Range("A1:C3").Address

- : enter image description here

? , ColumnWidths :

Me.ListBox1.ColumnWidths = "50;0;200" 'Hide column 2

enter image description here

, - , ?

ListStyle frmListStyleOption, MultiSelect frmMultiSelect.

, :

enter image description here

08/17/2012 : . , , .

Office Office (mscal.ocx):

enter image description here

:

2010 / -Access Office, .

TreeView

EXE , Microsoft Visual Basic 6.0. TreeView.

enter image description here

, ( Windows XP) OCX; .

, OCX .

+6

More articles:


All Articles