properties

I have a large list of: Property Name Address City State Zip # of Units Is there a way to create a map of all the properties in Excel? Either using an Add-On or Download software?

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...

Hi all, I've been studying form properties, and can't find what is causing this issue. In Design View, all my buttons can be seen on a single page without the need to scroll. When I open up the Form View, there is a large bar of whitespace where my bottom buttons should be ... I can scroll...

Hi all, I have a combobox that is throwing the #Name ? error no matter what I do. There are two comboboxes on a single form, and the rowsource and control source are now set up similarly. One works, one throws the error. I have removed a table from the database that the form property control...

Starting a few hours ago, when I open an Excel workbook and start the Visual Basic Editor there is a completely empty properties window showing only "properties ******** name>" and the X on top. Clicking the X does nothing. :confused: I use this to change the codename for sheets to address them...

Hello. Is there anyway to enable minimizing, maximizing, resizing, and scrolling with your mouse in a userform? I noticed that my userform does not have these capabilities and I can't find the properties to enable this functionality. Any help is greatly appreciated. Thank you!

Hi, I am trying to format a graph so that the x and y axis are identical to a Cartesian plain. So the Y axis crosses the X axis at the origin. It seems that I can't get this to work. I tried highlighting the Y axis and going to properties, then changing the min and max from auto to fixed...

Wondering if any of you have others experienced the following... 3-4 years ago, while using imported dates from a database in Excel 2003 (or maybe 2010 - can't remember) I realized that some of my dates were not calculating. I checked their properties - Excel said they were in fact dates. I...

My vision is not great. I have my code window set to a font size I can easily read. Can I change the font size for the Properties and other windows?

I have a model with 3 tables: Fin_Data, Dim_Prop, and Dim_Calendar. The Fin_Data table contains financial data for properties, the Dim_Prop contains property attributes, and the Dim_Calendar is a calendar table. Some of the properties do not have financial data available for every month. I...

Hi. I have an userform with a 2 buttons. The first, open a visio document with one sheet. The visio image have a serie of circles with diferents colors and diferents numbers. The second button get the properties, for each shape, and write the id and the text in a worksheet. I wan get the...

I have a workbook with a number of worksheets very hidden. Is there a way to stop users accessing the info in Advanced Properties?

I almost always want text boxes to keep their size and location regardless of what happens with the surrounding cells. So I end up manually right-clicking the border, selecting Size and Properties, clicking Properties, and clicking Don't move or size with cells. This page says that I can set...

Hi all, My dataset includes a column for the size of a property (in square metres). For a minority of the properties, this column shows an N/A. I need to use this column in measures, for example total property size, and then segment in a visual by say region. In order to make that work I need...

I've used the Clustered Sales example from sqlbi (Dynamic Segmentation – DAX Patterns) to good effect. In my case, the properties is effectively the customer and UnitTape contains the sales. OrigNumberOfPropertiesClustered = CALCULATE ( [NumProperties], FILTER ( ADDCOLUMNS (...

Hi there, ") Is their a way to change an item ( for instance "Groupname") in the properties menu for let's say 9 option buttons at the same time ? Thanks a lot ! Regards, Andres

Hi all, I've got a 'Summary' worksheet with a number of slicers and on a different sheet (called 'Risks') I have a macro that creates a new slicer on the 'Summary' sheet based on the name entered in a specific cell and sizes and places it according to numbers entered in specific cells. The...

Hi all, I'm looking for a simple code that can obtain the properties of a windows folder. On windows if you right click a folder and go to properties you can obtain the number of files/number of folders etc. in a few seconds. However, if you use the recursive method of looking through each...

I am trying to lock down the "Timeline" slicer from being moved and resized but still allow the user to adjust it. I know with all other types of slicers you can check the box under position properties "Disable moving and resizing." When I look at the position properties for the Timeline it...

Hey all, I have been searching for the last 3 and a half hours so I finally admit I need some help. I currently have an excel document, and it has a list of hyperlink functions to a few different word documents. I wanted to track all of these word documents in excel. So I hyperlinked...