excel vba 2013

  1. T

    VBA Code to lock the cell after data entering with maintaining the filter option

    I have a protected worksheet and need to have specific cells locked after data is entered. I would also like to keep the filter option working after locking the cell( protect the sheet). I currently have a working code that does what I'm looking for but it covers ALL the unlocked cells on the...
  2. S

    VBA to select range of cells down to bottom border - ?????

    Hey, so I will make this fast. I am looking for a way to select a range of cells, starting with A17, down column A, to where a bottom double line border is. There are no other bottom borders in the range. The range can vary, i.e. A17:A46; A17:A2345837, etc etc. All of the range's cells may...
  3. C

    VBA code for Submit/Clear Button?

    Good day guys. I'm trying to create a Data Entry using VBA code. I successfully created the User Form but I am having problem about the code in Submit / Clear button. So, basically I just want to fill up my excel sheet what ever I enter in my user form specifically in COLUMN C, I, J, and K. I...
  4. A

    Excel VBA Worksheet Change Event Causes Message Box to Appear Multiple Times

    The below code checks to ensure a certain cell has a value before changing the color back to the sheet's original color. By changing the color from yellow to the sheet's original color, the user is able to print. The issue is that once a value is entered, the message box keeps appearing when...
  5. S

    Worksheet_Change - Multiple Changes - Code not working ?????

    I have a worksheet with a Worksheet_Change sub in it. I have two sets of code in it. Each set, individually, works as planned (tested). But when together, for some reason only the first set is catching correctly. Here is the code: Private Sub Worksheet_Change(ByVal Target As Excel.Range)...
  6. S

    Update Pivot Chart upon use of slicer

    So I have 3 worksheets that each have a number of pivot charts on them. The pivot data is on a different sheet than the pivot charts. Charts and Data are on separate sheets. I have a number of slicers (4) on each sheet too .... all three sheets have the same slicers so that if I make a change...
  7. G

    Reducing the amount of code with Arrays

    This is my code for checking the system clock and comparing it with the dates of the tax year Sub dateesystem() 'decclare all variable to differnt type '------------------------------------------------- Dim StartDateMonth01 As Date Dim StartDateMonth02 As Date Dim StartDateMonth03 As Date Dim...
  8. V

    An Excel VBA file which able to open .dotm change it and save as an pdf for e-mail. Possible??

    Hi everyone I am trying to make a excel file with vba codes. Plan is that file save datas, choose information daily, open an existed word object (.dotm) change bookmarks I create and save it. All is fine till save as a .pdf and send e-mail via outlook app. I already do this in excel with active...
  9. M

    Copy rows from another file (without opening file) and paste in active file

    Hello, trying to do the title task (in Phase 1 & 3 of code below), but getting the type mismatch error when running. Please help, thanks in advance! Sub PhaseOne() Application.ScreenUpdating = False Call PhaseOneStepOne Call PhaseOneStepTwo Call PhaseOneStepThree...
  10. S

    Making text BLUR

    I am working on a project, where I am automating IE. Where IE is accessing "www.google.com", and typing "population" and clicking on "google search" button. Desire: I don't want to show what I am entering to the search box. Or I want the text, "population", to be blur or hidden, so that while...
  11. M

    dates, columns, conditional formatting, neighbouring cells (below/above)

    Hello everybody out there, I do believe that VBA code is needed for my problem. So please, be kind and help me. I have table with many dates (all dates are in one specific column). Cells with dates are filled without some special order. Filtering is not applicable, because of other data...
  12. C

    Excel VBA to calculate Euro in one column and USD in an adjacent column when currency value is placed in either column

    I am pretty solid in my excel skills but am still learning about VBA. I am trying to figure out the script for performing an automated currency calulation (currency converter) when the cell in the first column is selected and a value is entered. The adjacent cell next to it should perform the...
  13. R

    Excel Table Functions: a Find returns the sheet row rather than the table row

    I have a small program that is trying to find a cell containing a certain string and return the Row in the table where it is found. Here is my program: Private Sub test() 'Routine to move data to table from Molding Table 'Check to not overwrite current records but add new ones...
  14. R

    Opening a second workbook breaks the UDF in the first workbook

    I have a workbook, Book-A, that I have defined a UDF. When I open a second workbook, it breaks the UDF on the first workbook. How do I stop this? Rich
  15. R

    Find a cell in a table column that matches my criteria?

    I am using Excel 2013. I have a listobject excel table called Assembly I need to find the cell that contains "asmb1" in column "Item Name" Here is what I have that does work: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit...
  16. A

    VBA code for file save as in Excel 2013

    Hi, I have some code that needs to be updated but I'm not sure how to change. I am trying to save as into Excel 2013 excel workbook. This is the code I have: FileSaveName = Application.GetSaveAsFilename(InitialFileName:=ActiveWorkbook.Name, FileFilter:="Excel 2003 (*.xls), *.xls")...
  17. P

    To Format date over range of cells in Excel vba

    Hi, I am trying to format date over range of cells using Format(). Sheets("Details (Deliverables)").Range(Format(CDate(Cells(i, "N")), "dd/mm/yyyy"), Format(CDate(Cells(i, "W")), "dd/mm/yyyy")).Select I got error for this.I having Excel 2013. I tried using .NumberFormat but it is not working...
  18. J

    Alternate Filtering of Data Excel Vba

    Hi is there a way to make Excel column data alternating. For example : I would used it to evenly ditribute data to personnel so they would have a mixture of data and not only handling data with tagged as New or Old. Thank you
  19. A

    Split specific columns into mutiple work sheets delimited by a column as well

    Good afternoon, I was searching the forms and thought I would find the input to my hurdle. I am trying to extract records from a detailed worksheet into separate sheets but only specific columns. I thought I might find a script for each of these two steps and merge the scripts together, but I...
  20. M

    Read a Text File with VBA into Excel

    I have a huge text file that I want to extract specific data and put each one it into a column in excel. I not even sure how to start. I've only done simple code in excel before. The data in the text file looks like the following date. Report name Page number time run option: print...

Some videos you may like

This Week's Hot Topics

Top