Results 1 to 5 of 5

working with a Custom Type

Threaded View

  1. #1
    Registered User
    Join Date
    12-09-2017
    Location
    Israel
    MS-Off Ver
    Office Excel 2007
    Posts
    42

    working with a Custom Type

    hi guys!

    I'm not at all familiar with the proper technical names for what I want.... so I'll just demonstrate to you the end result I'm looking for:

    What i what is to create a custom type (named Estimation) used in the following way:

    Dim EST as Estimation
    EST.Type=Robust
    Where "Type=" would bring (intellisense) Robust , Adaptive , Standard or NoneStandard as possible constant options to choose from.
    The Estimation type has more stuff in it of course, but I'm focusing on this one particular property, in here.

    My question is this:
    Am I using the wrong object (custom type) where this syntax would be more (or only) typical for a custom Class rather than a custom Type?
    Is that why I have not been able to set it (and could never do...)?

    I just want a way to save me from explicitly typing "Robust" or "Adaptive" or another ... every time I want to configure the Type property for Estimation, but have an already set of constant choices to choose (to avoid typos and save time..).

    Thank you!
    Last edited by guyglk; 03-24-2019 at 05:22 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract Text and Numbers from Custom Type Cell
    By KMVKMVKMV in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-09-2017, 03:10 AM
  2. Error when selecting CUSTOM TYPE in chart menu
    By Numcruncher1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-02-2016, 12:15 PM
  3. Custom data type
    By excelishard69 in forum Excel General
    Replies: 4
    Last Post: 06-16-2013, 07:18 PM
  4. Loading Custom Data Type ?
    By dpenny in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-01-2007, 06:19 PM
  5. sharing a custom chart type
    By Papa Jonah in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-15-2005, 10:05 AM
  6. Accessing Property of Custom Type
    By Ronin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2005, 05:05 PM
  7. [SOLVED] Keep Pivot Table custom chart type
    By Jeff M in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-08-2005, 04: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