property

Hi guys, I'm given a data set on property type as a school assignment and i'm having great difficulty in creating graphs out of numerically-assigned categorical variables. For example, my variable on gender of property buyer has 0 = male, 1 = female 2 = joint purchase. Is there a way for me to...

I have determined an IRR of a commercial property from its cash flows after a sale in year 10. How do i go about figuring out what portion of my IRR comes from cash flows and what portion comes from the sale of the property?

Hi I am able to loop through all Userforms and all Controls but I need to loop through all all of the properties of each control. Property and Properties seem to be data types according to Intellisense in the VBA Editor but are not listed in the VBA data types list. Are these what I should...

I'm using this to populate a series of Comboboxes on a Userform from a dynamic named range; Me.Controls("ComboStaff" & i).List = ws.Range("NewAvailableStaff").Value It works fine until there is only 1 item left in the range and then I get an error, Is there a way I can avoid this?

In design mode for a form I sometimes will not be able to see properties for text box or form etc. To enable the property sheet in the immediate window I enter CommandBars("Property Sheet").Enabled = True Is there any way to always have the property sheet enabled? Or to do it a start up time...

Hi guys, I searched the forum and found some code which I was able to use in my form to create a lookup to populate other TextBox within my Form. The code works fine when matching and looking up the values for the other cells, but I am not able to delete the value/enter my own random property...

On my worksheet, in column A, I have 5 rows of data and a heading in cell A1. Say: Name a a b c d This is my code without using classes: Option Explicit Sub NoClass() Dim MyArray(1 To 6, 1 To 1) As Variant Dim i As Integer For i = 2 To 5 If MyArray(i, 1) <> MyArray(i + 1, 1)...

I keep getting out of memory error with this VBA script. and It highlights the following line : ReDim V(1 To WorksheetFunction.Combin(UBound(Vals), 7), 1 To 7) Can someone help me please to fix this error? thanks. This is the regular module: Option Explicit 'Set Reference to Microsoft...

I understand that there is 2 lists of control properties. The ones at design time (static) can be changed manually through the VBA Property Window, and the ones that can be changed at run time (dynamic). Is it possible to programmatically change the static ones so I can see the changes in the...

I seem to be confused with regard to ByRef and ByVal. Here, regardless of ByRef or ByVal, the result in the immediate window is 100. I though ByVal DOESN'T change things. Option Explicit Dim pabc As Long Sub Test() abc = 10 Debug.Print pabc End Sub Property Let...

What's the difference between a function and the Get Property? Both TestFunction and TestProperty generate the same results. Option Explicit Sub TestFunction() Dim d As Long d = MyFunction(1, 2, 3) End Sub Sub TestProperty() Dim d As Long d = MyProperty(1, 2...

Hi I have set up 20+ user forms with approximately 50 controls in each one. When designing the forms, it seemed inefficient to give a unique meaningful name to each and every control, so they are currently named randomnly, i.e CheckBox1 could be beside CheckBox101 but still related to the...

I have a variable, Var1, which is of type Class2. Standard Module: Option Explicit Sub Test() Dim a As Class1 Set a = New Class1 a.Var1.Var2 = 7678 End Sub Class1 Option Explicit Private pVar1 As New Class2 Public Property Get Var1() As Class2 Set...

Hello all. I can get the modify sintaxe correctly to AppliesToRange as below but I can't get to ModifyFormula1. Sub CFTest ActiveCell.FormatConditions(1).ModifyAppliesToRange Range("$L$2:$L$115") 'this works properly ActiveCell.FormatConditions(1).ModifyFormula1 "=$I2=1" 'this...

I have a class file that stores each control for a series of userform comboboxes and textboxes Class module: materialField Option Explicit Private fieldName As String Private fieldValue As Variant Private fieldValue2 As String Property Get Name() As String Name = fieldName End...

I want the scrollbar at the top, and I've seen solutions to use Sheets("Main").ListBoxes("List Box 1").scrolltop but excell says it's not a property or method. Does this only work with ActiveX? Can it be done with a simple form control? What about .topindex which the documentation from...

I'm unable to find a way in VBA to identify calculated columns in the data model. I can enumerate the columns Dim objMTables As ModelTables Dim objMCols As ModelTableColumns Dim objMCol As ModelTableColumn Set objMTables = ActiveWorkbook.Model.ModelTables For Each...

Hi, I don't need the horizontal scrollbar on my userform listbox, is there a property that disables it? Thanks!

I added a series to a chart and recorded as a Macro. The following VBA was recorded: Sub Macro2() ' ' Macro2 Macro ' ActiveChart.ChartArea.Select ActiveChart.PlotArea.Select Application.CutCopyMode = False ActiveChart.SeriesCollection.NewSeries...

I named the column W as S_Date, and tired to use it in my VBA code. But it doesn't work. I know I can use the named range in Range Property, but it doesn't seem to work in Cells. How to solve this? Thank you row1 = WS1.Cells(WS1.Rows.Count, Sheets("Template").Columns("<wbr>S_date")).End(xlUp).Row