+ Reply to Thread
Results 1 to 2 of 2

Excel VBA User Form Control Type Enumeration

  1. #1
    Forum Contributor
    Join Date
    01-07-2004
    Posts
    314

    Excel VBA User Form Control Type Enumeration

    Hi all,

    Using Excel 2013.

    Where is there documentation for Control Type Enumeration?
    Checked through Ref's on MSDN - cannot seem to find it.

    Alternative, I added a ll controls to a User Form.
    Is there a way to get the Enum value as Data Type Long of each control?

    thx
    w
    Kind regards,
    w

    http://dataprose.org

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Excel VBA User Form Control Type Enumeration

    Hello goss,

    I am not sure what you are looking for. If you are referring to controls on a VBA UserForm then there are no enumerations for the controls.

    If you are referring to controls on a worksheet which is being used as a "user form" then this should help...

    Enum XlFormControl
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] User Form focus on textbox control?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-24-2014, 11:12 PM
  2. [SOLVED] Stock control user form "database" in Excel 2007
    By ghurhu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2012, 06:07 AM
  3. Adding a control to a User Form
    By scantor145 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2005, 05:05 PM
  4. [SOLVED] user form & control properties
    By Mike Molyneaux in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2005, 04:41 PM
  5. [SOLVED] user form and frame control
    By Gixxer_J_97 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2005, 07:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1