I am trying to call a sub on a different worksheet but I got a run time error message. Specifically, I have two worksheets and multiple VBA sub s in those worksheets. In one of the VBA Project (say workbook1.xlsm), I have the following code: But I got the following error. The macros on both … Read more
Here is your problem statement: Evaluate the innermost parentheses: This is a range, but a range’s default property is its .Value. Unless there is a named range corresponding to this value, the error is expected. Instead, try: Or you could simplify slightly:
Try the code below (explanation inside the code as comments):
I am trying to develop a form to track invoices as they come in. The form will have a combobox where I can click on and select a vendor number. I want the textbox to automatically fill in based on the vendor number selected from the combobox. Here’s what I have so far: Worksheet 3 … Read more
Question 1 xlPaperUser is a User-Defined paper size that is assigned a constant value of 256. If this has not been defined, it may throw an error. Question 2 There is no way to create custom paper sizes in Excel, however you can create custom paper sizes on many printers. Under Page Setup, click the … Read more
I am working on VBA code in excel and i have the following piece of code When I run the code I get a compile error to debug and it reads Object Required. What is it asking me to do? This is a larger piece of the code:
Look closely at what you’re trying to do in this code: You’re assigning a “long” value to each of l and m and then calling them in the average function as if they were references to a cell. I suggest that you add a range variable, assign the location of the data you want to … Read more
The DA0350.dll must be registered. Try this: On the Visual Basic 6.0 CD (or whatever your installation source is), locate the Dao350.dll file, and then copy it to the directory c:\program files\common files\microsoft shared\DAO. (The Dao350.dll file is located in the \os\system folder on the Visual Basic 6.0 CD.) To register this file, click Start, … Read more
Google is full of information on this. As Hans Passant said, Form controls are built in to Excel whereas ActiveX controls are loaded separately. Generally you’ll use Forms controls, they’re simpler. ActiveX controls allow for more flexible design and should be used when the job just can’t be done with a basic Forms control. Many user’s computers by default won’t trust ActiveX, and it will be disabled; … Read more
Here’s how you can fix your code. Of course it’s not the best way to do date calculations, and you’ll also have to validate that there is text in the 2 text boxes, and maybe even use CDate() to parse the text to date values, but this will work for your current situation.