class

  1. G

    Vlookup help

    Can anyone help me with this. One of my sheets has info on student ID and the class they were in last year. The new sheet has the student id and the class they are enrolled in this year. If they both don't match it should say bad. Sheet two should look like the table below. The range is...
  2. S

    If X in C4, copy to E4, Dependent Validation

    I've set up Dependent Data Validation so when a specific Session is selected only specific options are available in the next two columns. However, the third column the user is to input a number. The only restriction is for the Session called Previous Group. Those two dependent validation columns...
  3. S

    Delete ranged names

    So I have an interesting one for you all. I have a master workbook I made for a gradesheet and put it in the public folder. When a new class starts the instructor will make a new folder for that class and copy the master book into that folder. It is still in beta mode, so as the classes have...
  4. B

    What are Class Modules

    Hi, I am new to MS Access and have never used Class module in Excel VBA either. My question is more regarding Access, can anyone please help me understand what are class modules. How they are different from regular modules. What are the advantages of a class module or why and when should we...
  5. S

    Referencing class variable(s) from another class

    I have two simple classes shown below for several userform textbox and spin button controls. Userform_Initiliaze event basically adds any such controls to relevant collections to manipulate later using events. What I want to achieve is to pass text from textbox class (clsTextBox) to spin button...
  6. D

    Advanced Query or VBA Code

    I have a spreadsheet that contains over 3000 rows of student data. The last two columns contain Staff Code and Class. I am looking for a way to add the staff code to the class (sometimes we have two or maybe three teachers). What I normally do is use the concatenate function. I sort the...
  7. A

    Class Not Registered Error?

    Hi, I have an Excel Workbook that is using Power Query to take 3 excel files and append them into one report. I have a VBA code that opens those 3 excel files which are connected to a SharePoint site and refreshes them to capture any modifications made to any of the entries. The issue is, the...
  8. C

    Prevent delete based on date condition

    <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">Hello, I have a delete routine below that works great for my purpose. I am trying to stop users from deleting class after a certain date. I have the date field (ExpiredDate)in the tblClasses...
  9. D

    Search highest value code in list

    Thanks in advance for your solutions to my problem. I have a long list of codes which looks like this : <tbody> E001 E002 E003 Q001 RW01 RW02 E004 RW03 Q002 RW04 </tbody> Where each code is the same length (4 digits). Where each code is unique. Where each...
  10. C

    Registration form - Ideas

    Hi.. I am looking for suggestion / guidance on the best approach. I have a user form that users can register for classes. They select they name and class they want. They can also go in and delete entry later if they decide not to take class. This works great. I want to make some enhancements...
  11. K

    Student Choice

    Hi, I am trying to make a process a little easier at the school I work in. 1 hour a week we have an enrichment time where different activities are offered to the children on a 6 week basis, they pick their preferences on a slip, then 2 staff members sift through all the slips and allocate them...
  12. D

    For each cntl trigger class module

    Hi I've dynamically created a number of textboxes on a userform. Each textbox was added to a class module with some associated attributes. I also have a number of option buttons to the side of the userform. By clicking the textbox, i can update the text in the textbox from the asociated...
  13. B

    Blanks in a pivot table

    I have a project due at work in 2 hours so I'm hoping I can get some help before that! I have a huge set of data with some blanks. See example below: <tbody> Order # Shipping Cost Our Charge Province Weight Class 100 $20 $10 ON 0-5 101 $10 BC 0-5 102 $30 $10 PQ 5-10...
  14. J

    IE.Document.getElementsByTagName("A")

    So I have some code which pulls URLs from URLs by tagname if it contains the If Instr in the code below. I'd like this to focus just on one section of the webpage, Div Class: Div Class: product-list-container and exclude: Div Class: recommender__wrapper The code is as follows: Sub...
  15. Collington

    Look for B1 value in another workbook, then see if somewhere in that row the value matches A2

    Sorry - no idea how to explain this, let alone do it! Think it's an index/match combo but just can't get it to work... Anyway what I'm trying to do: On sheet 1 we enter all of the entrants names and some other details in A-D, then in cells E-Z you can type in what classes they're entering...
  16. S

    Help! Excel formula - Pulling from data to another sheet

    Hello, I want to pull names connected to a category. I need help pulling all names associated with this category. The name column also grows throughout the year. Is there a formula to use that will pull all names associated to the column? OR Can I make a pivot table and then extract the names...
  17. T

    Formula Help

    I created a template that will take data and count the data based on a number of criteria. For example, in cell A1 I have State entered, in cell B1 I have class code, C1 City, D1 deductible, E1 Zip Code, F1 cost new, G1 year and in H1 I have a formula that would count the criteria based on the...
  18. N

    Can Userform, Modules and Class Modules of Excel be exported to Word ? with all the sub routines written in Userform, Modules and class modules

    Hello Before implementing i thought of asking the following Can Userform, Modules and Class Modules of Excel be exported to Word ? with all the sub routines written in Userform, Modules and class Modules of Excel using Excel 2013 Thanks and Regards NimishK
  19. E

    error 1004 autofilter method of range class failed

    Hi All, Using 3 lines of code below i run into error 1004 autofilter method of range class failed on the last line. Range("C12:P12").Select Selection.SpecialCells(xlCellTypeVisible).Select Selection.AutoFill Destination:=Range("C12:P12"), Type:=xlFillWeekdays Could someone please help...
  20. A

    Return All Small Value in Range

    Hi, Is there any way that I could return the value in a range with given certain condition. For instance: <tbody> Name Class Score Ali A 89 Alvin B 78 Barry C 23 Cynthia A #N/A Derry C 77 Kalvin B #N/A Ricky A 68 If Less Than 80, Name Class Score Alvin B 78...

Some videos you may like

This Week's Hot Topics

Top