procedure

Good day All Code below handle only procedure, how to use it replace Enum string "Level" "LVL" ? THX. Option Explicit Public Enum SecurityLevelp IllegalEntry = 0 SecurityLevel1 = 1 SecurityLevel2 = 8 SecurityLevel3 SecurityLevel4 = 10 End Enum Public Sub SecurityLevel() Cells.Clear [A1] =...

Hello, This is the first time where I got an error that I cannot find anything online about. I don't know when this issue occurs but sometimes randomly I get messages "Error in Activate Procedure" or "Error in Deactivate Procedure". Can anyone help me on this?

Hi All, I'm in process of wanting to create an Excel Spreadsheet which will have two input fields called "Collection Date" and "Delivery Date". The user inputs the date DD/MM/YYYY into these two fields and then clicks a button "Get Data". This calls a SQL Stored Procedure "EXEC...

I have recently shifted from Office 2010, to Office 2013, however my macro, which i use from Outlook is not working anymore. The functionality is extracting data from the Calendar, to Excel. Error message is as in subject title. Error No: 5; description: Invalid procedure call or argument VBA...

How can I make this formula either into UDF or a VBA procedure? INDEX(TOTAL_WAGES,MATCH($F12,Resource_Code_LIST,0),MATCH(INDEX(WAGE_DECISION_DESC_LIST,MATCH(WAGE,WAGE_TYPE,0)),WAGE_NAME,0)))

Hello, I confess I am relatively new to classes. I have declared an object variable at the top of module A thus: Public Teams As Collection The object is created in a procedure called "Create_Objects", also in module A: Set Teams = New Collection Without going into too much detail...

Hi all, I am in the stage of tidy up all my UDF and and Sub Procedure I wrote since several years ago. As of now those excel files scatter in many folders and sub folders. What I am looking for now is excel VBA with ability to loop through folder and all its sub folders and create a list of "...

Hello I know the error message about is a common one, however I can't trace why it is giving me this error. I have a Sub Auto_Open() in a module1 where I call a procedure under one of my sheets. This runs fine when I open the spreadsheet. In my procedure itself that gets called, I also have the...

I recorded a macro in 2016 and it works fine. Two other users on 2016 have also used it with no issues. I sent the file to a user on Excel 2013 and they get an Invalid Procedure Call or Argument error. I even tried recording the same macro from their computer and it gives me the same error...

Hi all, I've been searching for an answer to this for some time now and I'm sure there is probably a simple solution. I have a large table in which some cells have text and the rest are blank. On a separate sheet I would like to have a list to include the text from the cells and disregard the...

I need to execute a stored procedure from SQL Server into Access 2013 and add the results to a temp table. I will then be using the data in the temp table to perform multiple calculations and prepare different reports. I thought using a Pass through Query would be the best way. The following...

I am looking to write a procedure in Excel which opens a Word document. Challenge is that the Word document has an AutoOpen procedure resulting in the word document opening with a vbYesNo MsgBox. I want to select Yes all the time. And then continue with the AutoOpen word procedure. Again I...

Hi guys, On the internet (on page tutorialspoint.com) I found the following code for creating charts in vba: ' Procedure to Generate Pie Chart Private Sub fn_generate_pie_graph_Click() Dim cht As ChartObject For Each cht In Worksheets(1).ChartObjects cht.Chart.Type = xlPie Next...

Hello everybody, I don't have much experience with VLOOKUP and INDEX functions. So any help at all is greatly appreciated. I have a Totals sheet sorted from month 1 to month 12 and a separate sheet (BreakDown) to show the amount (in dollars) brought in from a certain type of procedure each...

Hello everybody, I don't have much experience with VLOOKUP and INDEX functions. So any help at all is greatly appreciated. I have a Totals sheet sorted from month 1 to month 12 and a separate sheet (BreakDown) to show the amount (in dollars) brought in from a certain type of procedure each...

In an Vba program in an Excel Workbook I’m using a listbox with reference numbers to make one choice out (property MultiSelect = 0 – frmMultiSelectSingle) on an Userform. There’s a procedure ‘sub <Iistbox>_Click()’. I try to use the listbox several times in the program but it only enters the...

I download a report every day. This report tells me how olda certain product will be by a future date. For my purposes, I have to then adda column and do a quick calculation. My calculation is as follows: Future date –Todays date = number of days. <o:p></o:p> For example, the product future date...

What makes a procedure too long? Is it the number of local variables or the sheer size of it (ie. number of code lines)?

I am looking for a procedure to calculate the statistic range in a list, A4:F19 is my example list and in H4:H19 is the range, in this little example you know is easy just =F4-A4 but in my data is more than 2 thousand lines. I would like to choose the interval of the range, mean select min and...

I have sub procedures which only contains one line, e.g. frmUserForm.Show. Is it possible to write a sub function in a way like Public Sub MySubProcedure(arg As Double): frmUserForm.Show the code above results in an error because I haven't ended the procedures correctly.