properties

I have a table (called myDB) that I want to use as the source of content for an ActiveX listbox. I enter that name into the properties of the ListBox and as soon as I hit enter, "myDB" disappears from the ListFillRange field in the properties window. I've successfully done this many times...

Hello, I have a dataset of property owners, some of whom own multiple properties. Whenever I add them to my database, I need to group up all of the property each owner has into one cell next to their name. Otherwise, I'll have 4 contacts with the same name just different properties. I have...

I am working on putting together some charts in VBA and could use some assistance with defining properties in the chart. With ch .HasTitle = True .ChartTitle.Text = aa & StartDate & " to " & EndDate .ChartType = xlLine .SetSourceData Source:=Range(RngStart & ":" &...

I have a 200 sheet .xlsm worbook with a lot of code. When I add a new ActiveX command button to a sheet, then click on "Properties" for the button, Excel crashes every time. If I open a completely new workbook, the same thing happens but only once. If I then access the Properties for the for...

Good afternoon, I'm trying to find out if I can set up a query to pull data based on two criteria on a single field. I have a table containing all the properties in the county and taxes owing back to the mid 90's. What I would like to do is query all the properties where they have taxes...

I am trying to graph the frequency of a series of cap rates but want to also show the average age of properties that have that cap rate. For example, the chart will show there are 3 properties with a 6.5% cap rate, 6 properties with a 6.75% cap rate etc. but I also want to see the average age...

I would like to be able to pull and combine data using drop down lists..so for example, I want to analyze financial information on my properties all combined as well as individually. So in my drop-down list say I have these to choose from: ABB LLC (combined) Apple Street Gold Street Blue...

Just idly curious. I can't access a shapes properties unless the sheet is activated. I'm guessing the process of activating the sheet loads the sheet shapes into accessible memory, but why? Are the sheet's shapes and properties stored in an abbreviated form that is only expanded to accessible...

Hi I inserted form controls buttons and active x control buttons. In vba window when i click anywhere on the sheet, i see Properties-sheet1 window, and when i click on any Active X control button, a properties window for that object appears. But when I click on any Form control buttons, no...

Hi We're upgrading to XL2016 at work in the nearish future. We haven't many macros here and none are mission critical, but are there any changes it's worth knowing about before the upgrade? I'm not worried about new features at this stage, e.g. new properties, but I need to know if anything is...

Hi For purpose of extraction to Power Query I would like to add columns to my tables with table name and row number. What are the simplest cleanest formulas I can use to do this? Presently hard coding table name and using row()-x formula for row number. My preference would be to somehow...

Morning all I have a programme (VBA macro) that extracts data from all excel workbooks that are moved to a specific folder and adds it to a master workbook. All works fine except for those rare instances where the workbook appears previously to have been connected to a data source. In such a...

Dear All, I have few doubt in VBA. when ever I write the VBA code i am getting Auto Properties list after dot(.). for some cases i could not the list while writing the code. but there is no error. even if I run the code I am getting the result. there is no error in code. But why the Auto...

Is there a way to get workbook connection properties (i.e. connection string, command text, etc.) from closed workbooks via VBA? Any direction on how to get this information is much appreciated. Thank you.

Hello Experts, I have 50 excel files, for which I need to change file properties manually and save files every month. Its really time consuming task .Could you please help me :help:for the same . I tried to paste property image & attach file but I am unable to do it here. <tbody> <v:shapetype...

Hi, Is there a way to change the owner and computer name of a pdf, It sounds a bit dodgy but what I am trying to achieve is a set the properties so every pdf that is created so it uses a generic owner name and computer name of which will not be any users. I looked at chip pearson's .bas files...

I need a macro that , in excel, shows a folder name, its path, # folders underneath it and # files in each folder. Each sub folder would also be listed and properties included in the spreadsheet. Like I was clicking on properties of each folder and sub folder individually (which I don't want...

I am looking for a macro that would take me to File, Info, Properties, Advanced Properties when I run the macro.

Hi, I need to assing some properties to my labels which are generated on runtime (on a Class Module). I am using their TAG and Controltiptext properties, I need some more proterties to set and control these labels during the runtime. I am not sure If i should use some property procedures. If...

I have about 50 workbooks I want to open, unlock the VBA properties with the current password and then re-lock with a new password and then save and close the workbook. Is this possible? Thanks!!