class

Hi I am new to power queries. I am a teacher and try to accumulate all the score for the whole school. I have 15 subjects and each subject have 15 classes to pull the score in. My goal is to be able to receive all the subject scores for each classes(15 sheets in 1 excel). Something like this...

I have a sentence in cell A1 that contains a few words, but I just want to take a specific word and put it in another cell, for example B1 and so on the sentence in cell A1 is as follows: Name: one; Class: A; Add: yes; Name: two; Class: B; Add: no; Name: three; Class: A; Add: no the results...

I have a spreadsheet that on the first sheet shows a list of classes down the right column and a list of instructors across the top row. X's are placed in the corresponding cell for instructors that are qualified to teach that class. Second sheet has a table of classes, instructors and their...

I have a userform that during run time creates 256 individual labels (they represent 5 charts with 53 weeks of data). This works great, I move the axis and scale as needed, I color code them based upon data in the spreadsheets, they have control tips to show their full value.s I also have...

Hello, this is a bit of an odd query, I am trying to convert a student timetable into an excel spreadsheet (then create a calendar with it), but the data I have been given is in an awkward format. It would be easier to give an example: I receive a cell containing a list of weeks a certain class...

Hello, this is a bit of an odd query, I am trying to convert a student timetable into an excel spreadsheet (then create a calendar with it), but the data I have been given is in an awkward format. It would be easier to give an example: I recieve a cell containing a list of weeks a certain class...

So, I'm updating an Excel table with data from another Excel table. I'm populating the information via a custom class "cls_Record_Title" (no validation - just public properties to collect the data). Theres no problem with that, all data is correctly collected. The "record" is then passed into...

Hi all, I have created application in excel, that contains multiple userforms and quite few class objects. Each class object is specific part of the project details (budget, dates etc.). When user update data in the field of userform, the application tracks the changes and update the class...

Okay, so here's what I'm doing. I'm teaching a class that requires essays to be submitted. The first one, since it was due on class 2, I am doing Pass/Fail - if you turned it in you pass, if you didn't you fail. I've created a monster spreadsheet to do my tracking for me. What I want is to...

Guys I need help. I run a code on VBA in my work , and on some pc i could run it and on other i couldnt. I read some answers for that error and they said that maybe its service pack for windows i check it and it wasnt . Can someone help me? Thank you

I have a collection with a custom class and I don't know how to print the items in the collection. Can someone help me? The collection = datacollection. The class = bobjclass class variables = country name, Amount, Account, Account name.

Guys I'm a newbie with OOP (Object-oriented programming) I need your assistance to develop a connection inside a class so I can get/access this connection on a module. Here below the function the connects to the SQL Server that is working fine. What I need is make reference to this function...

Can someone tell me why I get the error: "Select Method of Range Class Failed" Sub MICROPHARAOHVIEW() Application.ActiveWorkbook.Sheets("MICROPHARAOH").Cells(1, 26).Select End Sub

Hi, I have a spreadsheet and on one of the sheets named 'data' I have names (column C), areas (column E) and categories from row F1:P1. For easy reference I will call the areas 'class' and categories 'subjects'. It looks something like below...

Hi Using Object browser, Application class has the following: Activecell as range Activechart as chart Activesheet as object Activeworkbook as workbook ActiveWindow as winodw All of them make sense to me except ActiveSheet? Why is define as Object? What does that mean? Why they did not...

Hey, I need to grab the title of the first document from a search on 'https://infostore.saiglobal.com/en-au/Search/' For example; 'https://infostore.saiglobal.com/en-au/Search/All/?searchTerm=as%201400/' And paste it 2 cells to the right of the currently selected cell. From where i've found...

Hello I want to use a collection that contains different car objects. I'm familiar to do this in Java but I don't find the solution in VBA. I want to create a class car where I can create my car object with contains the following parameters make model year therefore I have to make a class...

I need to put a Array formula referencing a Class UDF (Matrix_Correlation UDF from Class1 Module). How to go about it? Selection.FormulaArray = "=Matrix_Correlation(RNG)"

I need a result from the following 18.5 or less = Underweight 18.5 to 24.99 = Normal Weight 25 to 29.99 = Overweight 30 to 34.99 = Obesity (Class 1) 35 to 39.99 = Obesity (Class 2) 40 or greater = Morbid Obesity I tried this but something is wrong (O10 is the reference field)...

"Hi I want to delete all rows in my table if Column I is 99. The below code give in and runtime error 1004 AutoFilter method of Range class failured The 99 is a number not text, so I also tried 99 instead of "99" but got the same error. Could it be because it is a table ? If so how can I fix...