vba coding

  1. tlc53

    Spreadsheet Operating Slowly - Improve VBA Coding?

    Hi there, I have the following VBA coding on my spreadsheet which functions as I want it to. The only problem is, it is quite slow and flickers a lot. Even when data is entered into a basic cell with no VBA coding attached to it, it acts like it is having a good think about it. Is there anyway...
  2. C

    Table Search -> Copy/Paste Code

    Hey all, I'm new to VBA coding and not quite sure where to start with this project nor do I know if it is 100% doable. Below is a image for an overview of what my data looks like: Imgur: The most awesome images on the Internet What I'm trying to accomplish: A table in the "Monthly Cals"...
  3. T

    Need to Bypass or Disable 'File in Use' Error Message on Personal.xlsb File

    Hello, The Personal.xlsb Macro file on my system is set to open automatically when Excel Opens (in the XLSTART folder) and is hidden from view, so that it is accessible for me to code and write to without having to manually open it. Normally, this is not an issue, but it has been an on again /...
  4. R

    VBA Code or Excel Function For Multiple Sheets in a Workbook

    I know that there are probably threads that have answered this before, but I figured I'd start a fresh one as most of them are pretty old. I have a workbook that was given to me where each participant receiving quarterly payments has their own tab (50+ tabs). Each participant has their own...
  5. E

    VBA Form coding issue

    Hi Guys, I have created a form in excel using VBA. The information completed is to be loaded in to a mastersheet via a command button. I have written the code, which ?I have copied here but have an issue with the part in blue bold Private Sub Cmdbutton_data_Click() Dim iRow As Long Dim ws As...
  6. B

    VBA command for copying active cell content only

    Hello folks, I tried the whole internet but couldnt find vba code for. selecting active cell , then f2 command, then selecting all the content of the cell, then copy all the content. I have to enter a lot of data from excel to external application which support only values and not normal data...
  7. D

    VBA Code for create object on excel sheet to attached multipal pictures file on another excelsheet

    Hello Everyone, I am not good at VBA coding, i would be grateful if someone would help me. I would like to create a button for attachment in excel sheet from where i can attached multiple pictures file which will paste on second sheet or " create automatically pictures tab sheet including...
  8. J

    VBA Coding broken code

    Hi All, I am very new to this and have been assisted to utilize VBA code for an excel spreadsheet. After a number of months using the code i realized that the intended operation was not happening and instead i started to loose data. The reason for the code that i have is to move a row of data...
  9. C

    Creating time difference box in VBA excel

    Couple of things I want to do here... 1. I am working in military time, and need both the cb_starttime1 and cb_endtime1 to be entered as a four digit number hhmm, but display as hh:mm. 2. I then need the tb_timedifference1 to calculate the amount of hours spent on the job. I also want this...
  10. A

    VBA code to use Tranpose from on worksheet to an other

    Hello, thanks for taking the time to help me out.... Sub Xpose() Worksheets("insertion_order").Select ' copy column E info into Row 6 starting at column C in worsheet "zone_chart" Range("A12").Resize(, 10).Value = Application.Transpose(Range("C6:L6")) End Sub I would like to modify this code...
  11. V

    VBA coding for the question

    Dear Sir, Suppose I write any number (Example 100) in Cell A1, the cells A2 to A12 should be filled with the same number automatically. And again in cell A4 I write any other number, the cell from A5 to A12 should be filled with the same number automatically. How to write a VBA code for this...
  12. V

    Complete Automation and Emailing from within Excel 2003

    I tried to find a post that already was created (in this year) for this type of issue. If I placed this in to the wrong thread please move it to the proper place. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I have gone though a lot of the postings...
  13. H

    Registration Product Keys

    Hello ... can someone point me in the right direction for creating a "Product password key". thanks HDfatboy03

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top