vba help

Hi, I am trying to utilize VBA code in my spreadsheet. I do not know alot about it. Can someone explain the steps. 1. open workbook 2. ALT F11 3 paste code 4. ALT Q now what? Do I now RUN the code? ALT F8? and then do I continue to enter my formula? Senerio: I have a column of numbers...

Hi, I’m an intermediate programmer but new to VB/VBA and rather unfamiliar with the VBA Object Model. I was tasked to build a "pusedo" vending machine program for a self-service concession stand. I am trying to sharpen my VBA skills instead of writing it in a language i already know. Here a...

Hi: I want to open all Excel files in a specified folder and have the following code, but it didn't work: Sub OpenFiles() Dim MyFolder As String Dim MyFile As String MyFolder = "\\G:\Functional Teams\Finance\2013\Consolidation & Reporting\1013\Financial Package" MyFile = Dir(MyFolder &...

Hi, I am setting up an excel file to use as a database (MSAccess currently not an option) with a data entry sheet and a table sheet. The data entry sheet is set up to use 8 columns per day times 365 days (data is entered in columns B to DHQ). I have set it up like this as it is the currently...

Alright. So I'm in the process of automating a good bit on my groups daily spreadsheets. For one UserForm though, I have about 1,400 lines of code. I'm trying to streamline some things. Can this bit of code be condensed from 86 lines to maybe 50 lines? Here's the code: Private Sub...

So I've been searching on the site for the last 20-30 minutes, and I think I'm just not looking for the right value....so I need some help. What I'm wanting to know is....can VBA rewrite an API URL based on certain values selected in either text box, drop down, or even check marks? My API URL...

hello i am new in macro,so please suggest me how to write a code for displaying multiple data in sheet2 row wise. i want to use IF condition with for loop

Hello all, I've been working on a code for a project I'm working on that will perform a vlookup from one workbook to the next and loop it multiple times until the end of the worksheet I'm working on. I keep getting a a few errors. It almost never works properly so I can't implement the code...

I need the following formula, which has been input to data validation,=IF($P$48="EXCLUDED",$P$48,IF($Q$44=5%,$V$43:$V$44,$V$41:$V$42))to return certain conditions in a dro pdown choice list with one of those options as default depending upon the prior selected choices. For example - if P48...

Greetings all I have a report that I generate every week that uses a pivot table to aggregate data which I take and massage into the format for the report. Once formatted, the sheet (Data Staging) is copied to a new sheet and named Six Month Rpt mmddyy. That works fine until someone asks for...

Hello, This section of code I am working on requires me to find an exact text (I tried lookat:=xlWhole, but I can't get it to work right). The problem being is when it searches for Q1, Q10 is an acceptable answer ans so on. I need to get the 4th occurrence, but my research into Nth occurrence...

Hey guys, I'm very new to vba, so I might be asking a stupid or obvious quesitons. However any help would be greatly appreciated. The task assigned to me is to format the data dump from a program to match excel entry format. I'm trying to keep only the first 10 characters in each entry...

Hi guys I am doing a programme at work and I am struggling to finish the macro. I am running a macro in a cell (j8), but I want to offset to the cell to the right and insert the following formula: =J8-((three worksheets to the left)J8) The formula i have is below Function addValue(number)...

Hi guys I am in urgent need of some assistance if you could help? I am working on a workbook that I use to report the monthly progress over our business. This involves duplicating the most recent tabs (three different sheets) and then updating their names. I can rename all the tabs easily...

Hello All, I'm quite new to VBA and I am in need of a solution. I've spent countless hours trying to figure it out, but can't. Any help would be very much appreciated. Here is what I am trying to do: I maintain commissions file. -Column A is the sales reps user ID. -Column B is the %'s of...

I'm working on a project where I have a listbox that is populated with values. I'm probably doing something stupid, but how do I make the list box disappear when the value is double clicked and still have that value remain in the cell? Thanks Brent

Hi! I desperately need some help with some excel macros, can anybody help please? I need the VBA code so that an excel macros will run once automatically when, for example cell A4 = 1. I've managed to get this far with the VBA: Sub copytohere() If...

I have built-in VBA functions that no longer work. I get an error message: Compile error: Can't find project or library. I have no idea how to solve this. The pop-up help is not helpful. Suggestions! Some examples of Functions that won't compile: string$() Left() HELP!!!!!!!!!!!

I have a master worksheet and want to copy/cut rows to new sheets based on the value in the first column. I don't need a sheet for every value, so I need to be able to specify which "values" I want it to pull. I would like it to paste the rows under existing data if the worksheet exists already...