class

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

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

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

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

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

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

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

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

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

Hello, I have a table which tells me which class a student is in <colgroup><col><col span="4"></colgroup><tbody> Student Group1 Group2 Group3 Group4 StudentA 2 3 4 6 StudentB 3 4 1 7 StudentC 6 5 4 2 StudentD 2 3 7 1 </tbody> I would like to change this into a list of students in...

Hi All, my first post so sorry if its in the wrong place! Im looking to make a spreadsheet for a local club which im involved with that will track their points throughout a season and show who is the winner at the end. Basically its a horse riding club and they have around five events a year...

Hi, I feel there should be a way to automate this, I'm just not seeing it. I have a list of participants, each have chosen 5 out of 8 possible classes. Classes are offered multiple times over 2 days, 4 classes at a time. I have the class times and schedule. My goal is to assign 'students' to...

I have a workbook with a master sheet and corresponding individual sheets based on class #'s. How do I paste multiple rows (i.e. rows 3,6,14 and 21)fro the master worksheet because they match the class number (Column B) into a new worksheet (call it class 001)? All the information in sheet 001...

i tried recording this macro but its giving me an error on the highlighted line, can anyone help Sub fxgxfbcfb() ' ' fxgxfbcfb Macro ' ' Keyboard Shortcut: Ctrl+Shift+F ' Application.CutCopyMode = False ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _...

Hello, I wrote the following code below. Anything referencing shapes 1-15, 101-115 and 201-212 work. Everything else does not and I cannot figure out why. When I run HideSignals or ShowSignal the macro does run, but nothing happens to shapes 21-32. This is true even if I rename them or create...

I need to get some data from html, but my code does not work for the first set of data the Tag = a Id = u_0_p and for the second it is via class Tag = div Class = _50f4 I was doing this but it does not work dd = doc.getElementsByTagName("a") .getElementById("u_0_p") '(0) .innerText dd1 =...

Hi everyone, I'm an educator who is having trouble with some code to write for a task I need to do. I have a spreadsheet with column headings and a first row of data as such: A B C D E F G H I...

Hi All, I have a spreadsheet laid out like below (headers as columns): <tbody> Class Start End Category Mod01 01-May-2019 10:00 01-May-2019 12:00 Sem Mod02 01-May-2019 11:00 01-May-2019 13:00 Tut Mod02 02-May-2019 09:00 02-May-2019 10:00 Lab Mod03 03-May-2019 10:00 03-May-2019 11:00...

Hello there. Most puzzling. The following worked first time I tried it, now it fails on the highlighted line with Object does not support this property or method Simple test Hotel class: Option Explicit Private pName As String Public Property Get Name() As String Name = pName End...

Hello How would I create a formula that updates automatically when I update/change the selections in my spreadsheet filters? I have a large spreadsheet with columns for school names, teacher names, class names, subjects, students and columns for test scores. I need to count the number of test...