parameters

Why does this macro not appear in my macro list? I'm aware that if it has "parameters" it won't appear but I don't what parameters are. If this is the reason, what parts of my code are parameters? Thanks Private Sub Button298_click() Dim i As Integer For i = 3 To 14 If...

I am trying to code parameters in excel VBA from an access query that has 2 date parameters. I have parameters in my code, but I still get an error code that says 2 parameters are expected. Sub UpdateForecast() Application.ScreenUpdating = False 'On Error Resume Next Dim MyDatabase As...

Before I get into the issue I am experiencing, I think it should be said that my expertise in this matter is extremely lacking, so pretend that we're on /r/explainitlikeim5. I'll also note that I have tried to do some extensive research across multiple sites and forums, but nothing that really...

I have data that sometimes changes dates. if the customer wants a date in the future, I want the formula to look at the first date. If it is in the past, sum the information based on the parameters, if it is in the future, continue with the parameters. The current formula is...

I am using the below Select statement, which works fine. However, when I change the values below in Red to ? as is done in the WHERE clause toward the end of the statement in order to use parameters defined in specific cells in a worksheet, I get a "Numeric Value Out of Range" error. I do not...

I really don't know how to ask this question, but I'll try... I have a userform that has severl textboxes for a user to input parameters to calculate production output. Everything else is working perfectly so far, except the [Save] function. This is what I need: When a user clicks the [Save]...

I get this VBA error when I try to execute a query with 3 parameters "-2147217887: Multiple-step OLE DB operation generated errors" It runs fine from Access and I have run many queries in VBA without an issue. I don't believe I have previously seen this error so hopefully someone can...

Hi, I’m trying to return a value from a large static table that includes a number of different parameters. <tbody> Feature 1 Min| Feature 1 Max| Feature 2 |Value 0.1 A 1 0.1 0.2 A 2 0.2 0.3 A 3 0.1 B 4 0.1 0.2 B 5 0.2 0.3 B 6 </tbody> Here’s an...

Hi all, I have a formula that I can't seem to get to work... =IF(AND(Z833>=1,Z833<=14999),"£1-15,000", IF(AND(Z833>=15000,Z833<=49999),"£15,001-49,999", IF(Z833>=50000,"£50,000+"))) Does anyone know what I am doing wrong? Thanks!

Hello All, I need to create a macro that takes three parameters (tab name, Row# and Col#) i have them in three different columns. Then based on those three parameters find the correct cell and highlights it in yellow...Anyone has an idea how to simply do this?... Thank you very much,

Hello all, this is my first post here. I have tried finding an answer to my particular problem and haven't been able to. This is a snippet of the data query I am trying to write: SELECT Source.Item1 Source.Submitted_date Source.From_ID FROM Database.Source WHERE...

Hi gang. I'm trying to pull from a tab in which Column A is a year, and Column B is a company name. How do I tell it to find the row corresponding to BOTH "IBM Inc" and "2017", and then return the value from the 10th column?

Looking for some help I have a spreadsheet which has around 20K rows of data, Im looking for a formula that I enter 3 parameters into a search box and it will calculate the average of numbers it finds against the search parameters in column D, Column D could have up to 50 different numbers...

I’m fairly new to Excel macros. I have an Excel 2016 form that I’ve created for some data entry. I want to be able to run a PowerShell script when a particular cell is selected. My issue is I can run a PowerShell script but I can’t figure out how to pass 2 parameters to the PowerShell script...

Can someone help with a question regarding an SQL connection to excel? im just trying to set 2 parameters (dates) in Excel cells and have the data in the query update accordingly Thanx

Hi, a few years back I built a sheet that would pull info from financial websites and had a parameter (the ticket symbol) set in a cell that when changed it would pull all the latest financial information down for that stock. However, with the Office 2016 web query format I can't figure out how...

I'm trying to set passed arguments directly to an array for ease of use. As an example what I currently do is similar to: Sub Macro1(arg1 As String, arg2 As String, arg3 As String, arg4 As String)Dim args(1 to 4) as String args(1) = arg1 args(2) = arg2 args(3) = arg3 args(4) = arg4 for a = 1 to...

Hi I have created a powerpivot report in Excel 2016 that imports data from several parameterized SQL Stored Procedures. The purpose it to allow individual users to only view relevant data; the model is quite data heavy so I want to limit the number of records at source. I have created 2...

I am executing a Stored Procedure via a Workbook Connection. It allows for 3 parameters. I, along with a few others, can change the parameters and Refresh the file just fine. However, a couple of other people get the Invalid Parameter Number error when putting in the same parameters as me...

Hello People, If cell A1 is not with pre-defined parameters, I would like code for a warning to pop up and cancel execution of the macro assigned to a format control button when clicked. Any takers? Thanks in advance .....