classes

March 2018 Windows 10 update has scrambled Excel 2003, both the spreadsheet and also the vba. I use vba, among other things, to 'compile' javascript into closure-compiled form. It appears to have lost the ability to understand classes. For example, I have a js class which includes...

Hello experts, I'd like to know How may I convert HTML tags to excel lines. I have a predefined list where the classes have fixed names: This is the excel file: http://lojadecapinhas.com/Dados_LI_to_Excel.xlsx Thanks

I have a spreadsheet in excel 2016 that contains the names of all the students in my school. The sheet has the students’ names, student id (which is unique for each student). One of the columns in the spreadsheet is ELL (Column I) which refers to English Language Learner. If there is a “Yes” in...

I am required to submit the minimum number of people we need to recruit for our training centre. I heard Solver can help, but I am unable to figure out where to put the constraints and how to set them up since I never used Solver and the problem I have appears to be too complex and I hope solver...

Hello I've been around the woodwork with this one, so hopefully I haven't gone totally off track. Got the feeling I'm straying into the OO problems of VBA/VB6... Desired Outcome: Creating (no more than 2 at any one time) multiple instances of the same Userform, at runTime, and then referring...

Hi, I am new to MS Access. I know nothing about MS Access. However I want to learn it. I have basic knowledge about (excel) VBA. Thinking about joining weekend classes for the same. Could you please advise me how should I proceed. Location - India.

Hello everyone and thanks in advance, I can not create a slicer that filters not only by the main table, too by a secondary table that should be linked with the firts table with field key that is the reference. In other words, the main table is the one of students with a unique ID that is...

I’m trying to create a timetable for the different classes of my school. The classes timetables will all be located in the exact same cells of different worksheets. Each class period (8h:30m to 9h:30m, for example) will have the info in 3 cells of the same column: C8 - Discipline_code C9 -...

Hi, I have a class module with various functions in it which are all quite similar. I have another function in this class which I want to act as the publicly exposed caller to these other function. It has two arguments, NameOfSub and NumberOfCalls. The idea is that the name of the sub-functions...

I've been coding in Excel VBA for a while, but am fairly new to using Class Modules. One of the classes I have created depends on another user-defined class that is defined in an add-in that only a few employees at my firm have. My issue is that whenever someone who doesn't have this add-in...

I'm hoping to get this working. My Excel project has a number of forms each of which can be opened from a number of buttons at the top of each form (i.e. a navigation bar - clicking a button opens the target form and closes the current form). At present each form has code similar to that below...

Hi, Can anyone help me with this? I have a class, lets say with Name, Address and Salary properties. And a Collection (Employees) with all the classes. Is there a way to search for the maxvalue of the Salary, from all the classes in the collection? Thanks!

Can I have class modules that contain other class modules as members of that class, like other OOP languages? If so how and when would the other class member be instantiated? Or would I have to Set it after creating and setting the object that contains it? Does that make sense?

Hi All, I have a module that is trying to store classes in a collection based off selections in a userform and I'm a little stuck. For illustrative purposes I've simplified it. MainTest is my main module Sub MainTest() Dim colTest As New Collection fTest.Show ..Does stuff with the...

Hello, I am trying to understand classes using VBA Excel. I am having a hard time digesting the whole idea of them. Can someone explain to me or direct me to place that was useful to you? I am looking for detailed examples. I have a vague understanding of them. Any help would be greatly...

Hi, I have developed a workbook for estimating project costs based on selected Labour, Material, and Plant components, but I've recently dicovered classes and collections and was wondering whether they could be used to develop a more efficient solution. The data is multi-dimensional, i.e...

I'm just starting to learn how to create custom classes and objects and I don't fully understand it all yet. I want to create multiple objects from my custom class. But, I don't know how many I will need (it will be different each time I run the program). Because of this, I can't create object...

Hi, I'm currently programming a macro for which it would be handy to expand the current Excel properties of an object. I'd like e.g. to expand the ChartArea object with a new property named "Country" (string) and an property named "QualityPercentage" (double). I've been messing around a bit...

Can anyone recommend a good place to earn a basic VBA Macro Certificate (preferably in a non-online class setting)? I’m an advanced Excel user who can basically use most functionally of Excel before crossing over into reading/writing in VBA. I’m considered the Excel guru at my company, but...

Does anyone know of an Excel 2007 class offered in the Dallas, TX area that doesn't cost $1000.00 to attend?