class

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

I am trying to build a general course calendar that would work for any course whether it meets 3 days a week, one day a week or last 16 weeks. In order to get the class dates listed in column A, I wanted to see if there was formula that would build this list if there was an input of data like...

We have a system that exports billing information for insurance purposes. The bills are typically generated via PDF, but business want them in Excel so they can do calculations and manipulations with them on a spreadsheet. Whenever we export a bill as an Excel file it comes out looking pretty...

Hello everyone. I could use some help with creating class memberships. I have about 600 students across 4 departments that need placing in about 16 classes based upon a placement test score, preference survey, and departmental membership. So far I have worked within the database using sort to...

Hello, I need a bit of help with Offset function. The below is the source data. <tbody> MONTH TYPE CLASS % JAN PA A 90 JAN KR A 100 JAN SE A 80 FEB PA A 70 FEB KR B 80 FEB SE C 65 MAR PA B 90 MAR KR A 80 MAR SE C 70 APR PA A 60 APR KR B 50 </tbody> Below is the OUTPUT...

Hello. I am trying to make a carshow judging sheet and I am wondering if this is possible. We judge and give scores for each vehicle for the class they are in. We also have specialty trophies that are judged but not issued scores like the classes are and we only give one trophy per winner so...

Hello I have stumbled upon a strange class called "Table" inside the selenium for VBA. Does anyone know the usage ? I tried many different ways to pass somehow the values ,objects or table element from HTML without any luck. Even reading through the C# source code doesnt reveal any clues...

Got this intranet website only accessible at work( so unable to provide link) but I've included the html code relevant to a drop down menu. I'm unable to get a handle on it , have tried by class, name tag, and id using.getelement/s method. There are two such drop down boxes and strangely enough...

Hi I want to know what is Me? Is it an object? if yes, what is the class? Is it used in Form only? Thank you.

Hello all, First and foremost I am not a excel wiz and just beginning. Background info: I recently have taken over an operations position of a militaryschool and I am trying to clean up the way some data is stored and presented. Currently I have been able to research and consolidate mostof the...

There are some of the Subs that when I call them from the standard module with my userform, I get errors so I have to place them in the userform module. I have not used the class module before. Can someone point out to me whether I am doing the right thing or not? Regards Kelly

Hello! The code below works fine to generate all possible combinations of 37 numbers choosing 6 at a time. That is, 37 combin 6 = 2,324,784 strings However, I don't need all the 2M plus output strings. I only need the output strings that contain the numbers "3" and "5". Of course I could...

Hi again - So I am trying to compare lists. I have 3 workbooks that I am using. #1 - Has Mandated Classes with staff names #2 - Has training records for all staff (current and retired) #3 - Is a master reference workbook What I'm trying to do is In #1 - create a formula that will look...

I have a form that gets data from a class but somehow when the nested sub that reads the data to the form gets terminated premature Private BA As BidApproval Private Sub UserForm_Initialize() Set BA = New BidApproval For Each c In Me.Controls If TypeName(c) = "ComboBox" Then...

In column B I'm looking to find single entry or duplicate entries that have a MIN combined value of 20, (and column D must not be blank). If so enter the MAX date from column C into column F. Example: Classes named "Class 2" has two entries (in column B), and together they total 20 students...

I have a class that groups several textboxes in a userform for event handling. Here is the class: Private WithEvents MyTextBox As MSForms.TextBoxPublic EnableEvents As Boolean Public Property Set Control(tb As MSForms.TextBox) Set MyTextBox = tb End Property Private Sub...

Is it possible? During control creation, you can assign a class event routing (click, change events.....) to a UserForm control (My method below) Set C1 = New Class1 Set C1.labelz = LAB Is there any possibility for re-assigning a control that has already been...