vba help

  1. U

    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...
  2. K

    VBA Excel 2010 Passing Data Between Userform and Worksheet

    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...
  3. H

    VBA to open all Excel files in a specified folder

    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 &...
  4. C

    Xl2007 Find Replace VBA Increment Column Letter

    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...
  5. D

    Can this Chunk of Code be condensed down?

    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...
  6. B

    VBA API Guidance

    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...
  7. S

    i want to display muliple records in row

    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
  8. D

    VBA Vlookup Code Error for Looping

    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...
  9. G

    Excel VBA Help

    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...
  10. J

    Checking Workbook for Duplicate Worksheet name, and prompting for overwrite if it exists.

    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...
  11. J

    VBA Find exact match help and Nth Occurance

    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...
  12. N

    VBA Excel - Keep only first set of characters in input

    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...
  13. S

    * Urgent VBA formula help

    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)...
  14. S

    *Urgent macro help please*

    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...
  15. N

    VBA needed to display original value inside cell.

    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...
  16. B

    ListBox help

    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
  17. B

    HELP!! Run Excel Macros IF..?

    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...
  18. M

    Excel 2010 on Windows 7- VBA Won't Compile

    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!!!!!!!!!!!
  19. C

    Excel VBA Copy Rows to new sheet based on values

    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...
  20. J

    VBA text to columns

    I'm pulling data out of an html source. I am currently taking it out line by line. It looks : <table class="lined fontSize90" summary="This table shows the distribution of employer businesses by size of business establishment in each province and territory."><tbody><tr><td id="t3r3"...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top