property let

  1. jaunito

    Overflow (#6) Error When Assigning a Date Data Type

    I have a class that imports date values from a worksheet and then stores them in a class along with a lot of other information. The problem is when I try to move from the private variable holding the date information to the public property, it is giving me an overflow error. I tested this two...
    • jaunito
    • Thread
    • class objects overflow (error 6) property get property let vba
    • Replies: 13
    • Forum: Excel Questions
  2. A

    Change Event for Multiple Check Boxes

    I have 25 text boxes named in the following manner on a UserForm Name: id_[X]_box 1<= x <= 25 I am trying to write a program which can register a change event for all 25 boxes and populate the corresponding [DESCRIPTION] Labels. Naming scheme for Description Labels Name: desc_[X]_label 1 <= X...
    • abhijeets1991
    • Thread
    • change check event class module class modules excel form component label property property let property set textbox userform userform_activate userform_initialize vba withevents
    • Replies: 3
    • Forum: Excel Questions
  3. L

    Strong typing TempVars

    Hello. When developing, I have found it convenient to use TempVars because they maintain state even when my VBA project does not. In addition, I don't have to run a load procedure every time I restart my code. To provide a bit of validation and intellisense, I wrap them in properties in a...
    • Legacy 456155
    • Thread
    • access application.run callbyname getters maintaining state property let property set setters tempvars
    • Replies: 2
    • Forum: Microsoft Access
  4. X

    Optional Arguments in Properties of a Class

    I have a class for a cylinder and i want the user to have the option not only to read the volume of the cylinder but to write the volume and preserve the height, radius or proportion by user's choice. I'm with this code for that condition: Public Enum PreserveRelationType PreserveRadius = 0...
  5. P

    Property Get, Property Let functions

    Hi, I am trying to understand Class objects and have the following question regarding Property Get and Property Let functions. Functionally, it seems they are just assigning or obtaining values for the property variables. Why can't we just assign them directly as values to variables instead...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top