excel 2016 vba

  1. E

    How to copy values from one workbook sheet to another, based on criterias ?

    <button title="This question does not show any research effort; it is unclear or not useful" class="js-vote-down-btn grid--cell s-btn s-btn__unset c-pointer" aria-pressed="false" style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image...
  2. D

    VBA alternative to copy paste syntax that doiesnt use paste .... clipboard popup

    Hi, if i use the current syntax with this macro i get an annoying "clipboard has a lot of info on it" popup. To avoid it i would like to use the non paste method, but i cant figure out the appropriate syntax for the situation. Thanks for any help. This is the code section in question...
  3. C

    VBA to Export data into Word and generate PDF report

    Greetings my fellow Excel enthusiasts, I am hoping someone here can help me develop a code that will export data from excel to a word template, generate a report/proposal and attach it to an email in a pdf format. I already have the code to generate the proposal but can't seem to figure out the...
  4. K

    Saving an excel 5.1/95 editor customization file (from 97-2003) format to 2016 format .xlsm format

    I have upgraded to Excel 2016 from excel 97/2003. I have several workbooks with macros in the old format. When I attempt to save them to the .xlsm file format, I receive a message stating that: "This workbook contains one or more of the following features that are not supported by the...
  5. R

    Protecting and Un-protecting Workbook

    Currently I have a workbook that my end users fill out and submit to make changes to spare part info. When I receive the workbook I transfer the data to a repository file that is used as a search tool. Currently the repository file can be accessed by my end users, but some of them make changes...
  6. W

    error handling variables

    Hi, Can anyone help with the following? I have some code below that doesn't seem to work. My first question is why? and my second question is- is there a better way of solving this problem as the client seems to alternate between values for 'Forename' eg 'Firstname', 'First name'...
  7. V

    Highlight Selected Cells

    I am trying to create a macro that will highlight cells already selected. Below is the code I used but that is only working for the active cell. How can I alter the code to highlight all the cells I selected. Example: Cell C15 is the active cell and cells C15:C20 are selected. When I run my...
  8. R

    VBA Copy & Paste values & Formats between workbooks

    'My code is running through without error all the way to Msgbox. However the values are cleared from "WbRevDash" workbook and new values are not pasted in. The ranges are just blank. Any suggestions are helpful! i think it has to do with this part of the code but im a rookie and rely on the...
  9. S

    Unresponsive ribbon after opening new workbook Excel 2016 VBA

    I'm quite a rookie when it comes to programming, however I have been able to build a couple of useful applications in excel, which automate some of my everyday tasks. Currently I am having an annoying issue when trying to open a new workbook using <code>workbooks.open()</code> in Excel...
  10. R

    Workbook Security

    I have a workbook that I only want certain users to be able to open. I have a list of network usernames that should have access on a worksheet called "LISTS". The list of usernames is in column "M" (range M2:M159) that has a dataname of "usernames". How do I set up some VBA code to look at...
  11. R

    Automate emailing current workbook to end users

    I currently have a workbook that employs userforms that my end users fill out to send in part maintenance requests. Once we receive the workbooks from the end users I process their requests into out SAP system. Once I process the data, I have to click the email icon in my quick reference bar to...
  12. R

    Submitted Data from a Userform is not Posting to a ListBox

    My workbook uses userforms to create a new row in a three different table on three different worksheet in the same workbook. I have a listbox (LB_01) on the userform, but am not sure how to get the new data submitted from the userform to post in the listbox since I am using one userform to...
  13. R

    Conditional Formatting not being copied when new row is added to a table

    I have some code that creates a new line in 3 different tables on three different worksheets in a workbook when data submitted through a user-form. All of the formulae are copied from the line above and all of the data from the user-form writes to the correct locations, but I have a total of 5...
  14. R

    New row added to table does not bring down formulae and conditional formatting from the line above.

    I recently got my VBA code working to create a new row in my tables without overwriting data in the line below. The issue I am having is there are some cells in my workbook that have formulae and some have conditional formatting that the new table row needs to inherit from the line above when...
  15. R

    Problems with Adding a new line to a table

    I have set up some command buttons that open user-forms for my end users to enter data into in order to update tabs in the workbook. I have set up three tables, one in each of the three tabs. The problem is, in two of the three tables a new line is not being created in the table. It just...
  16. R

    .xlsx is already open...

    I have a large workbook with many worksheets within it. The end users fill in the user-forms and email the workbook back to me. There is a "SUBMIT" button in the workbook that uses VBA code to transfers the data submitted to another workbook that is used as a repository. I do not have any...
  17. S

    Using * to find a worksheet name so I can know what the worksheet number is

    Hello, I have a worksheet with a long name "Timeline_123456789.24", and I want to know what sheet number it is. I don't want to have to type the whole name, since it's the only worksheet with this name. I was hoping to use "Temp*" to find it but it doesn't work. Is there a way to use a...
  18. N

    VBA - Copy certain columns, but need to replace data on the ultimate sheet

    I am using code to copy over certain columns if two conditions are met, however, I would like for the code to replace what is already on 'Emerging' (the ultimate sheet). Any guidance would be much appreciated. [code] Sub Emerging() Set i = Sheets("Under achievement data") Set e =...
  19. S

    If Duplicate Copy

    I have names in Col(A) and data in col(B:R). No duplicates in Col(A). Col(B) are dates Col(E:K) have data from 2017 Col(L:R) have data from 2016 I import new data (for 2017) to Col(Z:AG) After processing new data, it's transfered to Col(A:K), last row + 1 Now I have many duplicates in Col(A) and...
  20. E

    VBA to Select All Checkboxes FormControl

    Hi I have a code to select/deselect all checkboxes with one "master" checkbox. This code is for OLEObjects/Active X controls, and im having a hard time rewriting it to work with Form Controls checkboxes. Any idea? Private Sub CheckBox1_Click() Dim i As Integer For i = 2 To 39...

Some videos you may like

This Week's Hot Topics

Top