Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have several user forms that I use to calculate costs of different types of
products. One userform per product. I would like to know the advantages and disadvantages of using variables or my own user types. For example, ' user types in standard module Type Sign SignHeight As Double SignWidth As Double End Type ' userform button code Sub Calculate() Dim EMC As Sign With EMC .SignHeight = TextBox1 + TextBox2 .SignWidth = TextBox3 + TextBox4 End With End Sub VS. Sub Calculate() Dim SignHeight As Double Dim SignWidth As Double SignHeight = TextBox1 + TextBox2 SignWidth = TextBox3 + TextBox4 End Sub -- Cheers, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
clearing a user-defined Type variable | Excel Programming | |||
Type Mismatch: array or user defined type expected | Excel Programming | |||
Clearing all values in a User Defined Type variable | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
User Defined Type Structure - want it to be variable not numeric literal | Excel Programming |