operation

Hello all I really need your help as the topic title says I need to find the minimum, maximum, less than 4000 among the selected listbox items. AB1EmployeeSalary2Gilmore34403Stone67804Horton102445Rice54326McDaniel205447Fowler123228Paul54409Burns765610Robertson4568 I already have a form, but I...

Hi I am trying to calculate the start date of the first operation based on the start date of the second operation. Typically this is always going to be 7 days (5 work days) before. I can do this easily by just deducting 7 from the second operations start date however I have a calendar lookup...

Afternoon all, Looking for some help/advice please... I hope this makes sense. I have a holiday file which is set out in a similar manner as below and tracks the full year. The actual file has around 400 employees in it but for the sake of this I've just classes a few as different job types...

Hi all, i have the below piece of code that i run every 200 milliseconds. It works fine however i am looking for a better, more efficient way of producing the same result. I use AutoHotKey to get information from Excel and quite often i will get a Callee error, i assume this is because Excel is...

Is there a maximum number of labels you can use on a form? Suddenly I cannot put any more labels on my form. I'm at around 35. Every time I either try to copy and paste a label or create one from scratch from the Toolbox I get the following errors: From the Toolbox: "Could not complete the...

I've designed a simple userform with 3 radio dial buttons, an OK and a Cancel button. How do I write the code so that when a user chooses OptionButton 1, then hits OK, the operation I want to perform is performed. I feel like I should be getting this more easily! Appreciate help and guidance.

Hello, I am new to the forum, thank you for having me. I am trying to learn some basic VBA for data entry purposes at work. My goal is to create an easy to use userform as a type of record database that can add new, insert, and delete records. I have nearly the entire thing functional, but I...

Dear all, I would like to fix the operation range from A1 to K20, prevent operator to disturb other range setting & data, please help to teach how to fix it & back to normal status. Thanks for help. Cannny

I need to compare to columns using index/match but round each value before comparison. Could create a dummy column but that is very cumbersome and ugly. is there a way to perform an operation on each cell value before the comparison =match(round(a6,1),Sheet!A6:A1000) I need...

Hello, I set up a power query from folder. When I put in another folder I receive an error that says OLE DB or ODBC error: Expression Error. The key did not match any rows in the table.. An error occurred while processing table 'LDP5'. The current operation was cancelled because another...

Hi to all, I want to identify the last confirmed yield and operation activity from the same Order. Some times the balance not complete the last step. So I want to know in wich step is the balance. Order: 215775959, Last Balance = formula?? <tbody> Order Operation/Activity Operation...

Hi to all, I want to identify the last confirmed yield and operation activity from the same Order. Some times the balance not complete the last step. So I want to know in wich step is the balance. Order: 215775959, Last Balance = formula?? <colgroup><col width="72" style="width: 54pt...

Hi, I´m struggling with extracting data from an XML file. All I need is the "Status" of each SID listed in XML file, where can be up to 50 different SIDs. This is the example of XML file. I have solved extracting 1 status (function is down below), but it is really very slow (1 SID = 1 second...

Hi, i am curikus whether it is possible to set a macro for afterupdate action for created in runtime combobox? I get an error for not supporting such operation: ...'creation of cb on button click MyCB.afterupdate = "mymacro"

I have a set # of operations, each requiring a set time to complete. Is there functionality in excel to identify operations that sum to a max amount of time, group those operations, and then sum the next operations up to a max time, and so on... Ex. Operation 1: 50 seconds Operation 2: 30...

Hello all, first time poster here so please bear with me. I have a project where I am trying to write code to be used as a tamplate across many projects. It has 2 sheets (to start). The "Master" sheet, which is where all the information is initially inserted, and the "Hidden" sheet, which is...

Hello, Gents, I facing the issue when trying make new workbook which must store our equipment operation and history log, the workbook hast two worksheet, in the first worksheet, must be something like entry form when you fill the form and hit submit( I don't know another method), data must copy...

Hello, I was poking around trying to find some code to create a pop up progress meter when a large spreadsheet i have exceeds say 30 seconds. The file is large with many array formulas and a full file calculation can exceed 3 hours. I was looking for a visual indicator to show me what's going...

Hi, I have a userform which is being used to import data (that has been copied onto the clipboard from another sheet). I want to make the userform paste it in - but the range of it may be variable. Is there any way to do this paste operation by only specifying the starting cell (A1)? Similar...

Hello everybody. For one specific site, I've problem in logging in. When the macro runs, the id is correctly written in its field, the same for the password, but clikking the button the operation fails with the following alert as if nothing had written: All fields are mandatory...