help me with vba

  1. S

    activex buttons and activex checkboxes

    Hi I am trying to create a worksheet to keep track of good and bad things that are happening to certain employees. Here is a test sheet that I put together just need it to be able to actually work. What I want is when I check the employees in the list and press the button labeled good it adds...
  2. M

    Reg-Ex /String Split HELP Needed.

    Hi Guys, Long time user but first time poster. I have always been able to find solutions and model them to my usage from this gem of a website. Kudos to the content here. I have a deadline on Monday and need to somehow gather a lot of info from a thousands of rows of product...
  3. M

    Range question

    Hello, I am new to VBA and was wondering how I change my range to go to the end of the data. I have reports that vary in row number everyday. At the moment I have it set at 200, but I would like it to just go to the end of the data. Here is what I have so far: Sub Macro3() ' ' Macro3 Macro '...
  4. S

    Email from excel

    I have found a program that will allow me to send an email from excel to people. I have been playing with it and i have tested it, and it works. However what i am trying to build is a program in VBA that will build an email address. lets say A1 is first name. B2 is last name. and attach that to...
  5. A

    Run time error 13 mistype. how do i stop this? please

    hi i am getting a run time error 13 mistype when i copy a cell from one workbook to another. The cell just contains an address. on the workbook i am copying to it has some vba running. The code is used to take a name from cell D3 and rename the tab on the bottom. i am not even adjusting this...
  6. S

    My Code crashes Excel & VBA (suggestions?)

    Moshi Moshi I am very new to excel. I learned it because I suddenly was given a large amount of data to organize. Unfortunately, I cannot figure out a way to make the code below run without crashing after spitting out a few solutions. By "crashing" I mean I am forced to restart Excel and VBA...
  7. A

    Macro for Mail Merge with CC and Attachments

    Hi, Have been using the forums for a long time for various excel related tips and help. However I cannot find a solution to my current problem and want your help. :) I have to mail multiple people, both in "To" and "CC", with each mail containing a separate PPT. Now, I have found macros for...
  8. H

    2 Combo Boxes, using TAB to change active

    I'm currently using 2 combo boxes setup from this website http://www.contextures.com/xlDataVal11.html In column B, I'm using it to pull from a list of names. I'm looking to be able to TAB from column B, to column C were I have a list of positions. I've tried inserting more code under the...
  9. B

    Open an Opened Excel File

    Hello, I have an Excel File where i have all my projects and a button so when i need to open a project i just click on the button to open it. but the problem is that when i already have that file open and i click on it again it doesn't let me open it without erasing the data i had worked on...
  10. T

    VBaA - Scroll Bars to change date in a cell

    Hi Bit of a novice at VBA so any help anyone can give me would be very much appreciated. I am trying to add a scrollbar to a spreadsheet that changes a date in a cell. I have managed to fix the bar to cell to change the date however I need to have a range of 31/01/2012 fixed as the minimum and...
  11. D

    VBA Loop

    Afternoon all, Looking for a bit of help with looping... Basically I've created a macro that gets the user to enter data via input boxes and validates the info they have entered, when the format of the info is incorrect I have an error message pop up, when ok is clicked on this error message I...
  12. A

    Help with EMAIL macro

    Hello everyone, I am new to the forum and am really stuck with this macro. I have searched and found multiple macros regarding emails and have had them work with one exception. The range that i am pulling the emails from has blanks. The list starts in cell BD9 and goes until BD45. The macro...
  13. D

    Using VBA to remove a row which contains a keyword

    All, I have a workbook which I am using to track a large number of deals. Column G in the Tracking Report provides a "Deal Status". I was hoping someone could help me with the VBA code to do the following: 1) go to the last active row in Column G on the Tracking Report worksheet 2) Begin...
  14. J

    VBA to build table based on 2 spreadsheets

    Hi Guys & Gals - I really need some with VBA. I have two spreadsheets and i need to build a table out of them. First spreadsheet tells me which builds are against which equipment numbers (the builds are the A numbers across the top) <tbody> Eq No. A465 A506 A507 A508 A510 A511 A514 A525 A561...
  15. T

    Create a Floating Box Containing Self-Updating Cell Navigation Info

    Hello. I'm using Excel 2007. I'd like to create a sort-of ever-present, floating note that helps me navigate quickly through my alphabetically organized sheet. The most direct/quickest way I've found to navigate up & down a sheet is via the Name Box. What I'd like to have is a floating note (or...
  16. A

    Help with looping a copy/paste function in VBA

    Hi everyone, have a situation that I'm wondering how to loop the action to save me some time. I have 340 assignments, every 3 cells is grouped into a new assignment. Assignment1= Columns B,C,D Assignment2=E,F,G Assignment3=H,I,J My issue is that I need to copy/paste the formulas for B5,5C...
  17. M

    Help Cutting/Pasting Rows within Same Sheet

    Hi, Should be a pretty simple code, but I am not very experienced with VBA. I have a list of stock holdings with various data (cost, ticker, etc.) in B1:K50, which is sorted alphabetically. I want them to stay alphabetical based on Column b (stock name), but I would like to cut and paste the...
  18. H

    Need tutor for a VBA assignment

    Hi, this is my first time posting in this forum so I'm not sure this is in the right place. To begin, I took an introductory excel class that focused on some basic and intermediate formula applications. We started learning VBA two weeks ago, but I've been sick and haven't been able to come to...
  19. C

    Running similar to sumproduct calculation using VBA.

    Hello, I am trying to count occurences of a combination of 3 columns. The formula I have counting them is "=SUMPRODUCT(($F$2:$F2=$F2)*($L$2:$L2=$L2)*($N$2:$N2=$N2))". So this counts the unique occurences of these three values in this row from row 2 up to this particular row. However since I am...
  20. E

    error on sending email - 2 lines of code i need help on

    i need help on 2 lines of code Sub sendemail(subject_line As String, mail_body As String) Dim olapp As Outlook.Application Set olapp = CreateObject("outlook.application") Dim olMail As Outlook.MailItem setolmail = olapp.CreateItem(olMailItem) olMail.To =...

Some videos you may like

This Week's Hot Topics

Top