public

Morning all, Quite a novice, but I have inherited a migration tool in which it runs a macro and copies all data from various excel spreadsheets and places it onto one master copy during the process I receive a "run time error 1004 method of rows of object global failed" the coding looks...

Morning all, Quite a novice, but I have inherited a migration tool inwhich it runs a macro and copies all data from various excel spreadsheets andplaces it onto one master copy during the process I receive a "run time error 1004method of rows of object global failed" the coding looks like...

I continue to have problems getting the hang of VBA's structure (my fault, I've not taken the time to run though some lessons properly, been running and grabbing just to get certain parts working). The following gives me a byRef argument type mismatch. The last section is my call, and it is...

Hi, I have a simple piece of code that calculates the mass of a gas at a known pressure within a fixed volume (please see below). However, when I run said code, I get a 'Run-time error '6': Overflow' error. When I scroll the curser across the offending line (i.e. m(1) =...) the last bit in...

I have sort of painted myself into a corner with creating a pretty in-depth vba project and my "hack" is to hide the workbook behind the userform. I know, I know, I should have used VB Studio since I'm trying to emulate a "standalone" application. Regardless, what I have I can insert into each...

hi all. I am having a little trouble working out a couple of formulas. What I have is the following: column A: DATE column B: START TIME column C: FINISH TIME column D: PUBLIC HOLIDAY DATES what I need to calculate is the following 5 different formulas: 1 formula If the date is between...

Im Trying to learn how to use classes. The first one works like as charm but the second one is a real pain and I cant figure ot the issue. For som reason it works if I remove the technican1 get property. But I need to write and read from the class. It returns : Definition of the...

Hi, Wondering if anyone can point me in the right direction here.... I'm not sure if it is possible, but what I want to do is make a public function on my workbook that searches for a specific text on a specific row of a specified sheet. (The idea is that then code on other sheets can refer to...

I've been trying to figure out something for work, initially to break down the component parts with formulas and then produce a result. It finally dawned on me i might be better off writing a UDF for simplicity, and then I hit the snag I don't know enough about them to even start a small one (A...

Hello folks: I have the following global variable: Option Explicit 'Public declarations for the project Public locationCode As String I then reference like this: Public Property Get locationCode() As String 'Declaration to access the data entered in the 'locationCode from anywhere on the...

Hi guys, So I have some VBA. I am declaring a public variable as integer in module 1 and lets say for example in module 1 it is declared as a value = 19. Public batch_audit_col As Integer batch_audit_col = Application.Match("BATCH1", Dash.Rows("1:1"), 0) Then module 2 starts and I do not...

Hi folks. My question is regarding VBA function: ActiveWorkbook.EnvelopeVisible = True As you probably know, this makes it possible to send a mail directly from Excel when the Send sheet button is pressed. link to a picture of the button I am talking about: https://imgur.com/LrYSi17 This has...

I have active-x radio buttons which when they are clicked are preventing to access any excel cell. Cells are all accessible until one radio button is activated. The worksheet is unprotected. Main sheet set-up code has nothing wrong, see below: Public StrFileDir, StrFileName, StrFilePath...

Using this code to get rid of extra character but then need to multiply by 1 to calculate dates correctly...I'm still actively working it... Public Sub Remove() Dim oCell As Range Range("B8:BU172").Select For Each oCell In Selection oCell.Value =...

I keep getting out of memory error with this VBA script. and It highlights the following line : ReDim V(1 To WorksheetFunction.Combin(UBound(Vals), 7), 1 To 7) Can someone help me please to fix this error? thanks. This is the regular module: Option Explicit 'Set Reference to Microsoft...

First, I'm a little embarassed to ask this, and any tutorial which actually covers this woudl be wonderful. I have looked, but haven't found. I am new to VBA and am attempting to get the environment. Here are some of my questions: I am VERY confused as to how to set my global variables...

Hi Anyone who could correct me for my error Basically Not getting right Value in Textbox1.Text and Label1.Caption when clicking on Combobox1 In module <code> Option Explicit Public arrayProdWs(1 To 2, 1 To 2, 1 To 2) As String Public arrayAccWs(1 To 2, 1 To 2, 1 To 2) As String Public...

Hello guys I’m not a very good user of Excel on Mac and i’m an occasional teacher. For many long time, I use a macro called « Stataix » withe help me to draw dot plot graphic. I know it’s inside Excel’16 now but I can do some thing with this macro I can’t do usually with the new version of...

Hi In Gen Module Option Explicit Public curRec As Integer Public a$() Public b$() '------------------ in Userform1 Private Sub UserForm_Initialize() curRec = 1 ReDim a$(1 To 15) ReDim b$(1 To 15) With Sheets("Sheet1") Userform1.textBox1.Text = .Cells(2, 3).Value...