user defined

  1. L

    Macro to Create New Folder using User Defiend Pathway

    I have a code that creates a new folder to a specific pathway but the issue is now we need to be able to allow the user to define the pathway (location changes weekly and by user). I can't figure out how to get it to allow me to let the user pick where to create the folder. Current Code: Sub...
  2. D

    Pasting data from other user defined workbook difficulties

    Hello all, I have been working on this code to 1. let user pick file 2. copy all cells that contain data on sheet 1, 2, 3, 4 and over 30 3. paste into first blank row of source workbook on Sheet 4 For some reason this seems to only paste one cell into "A" on sheet 4 on the first blank row of...
  3. B

    Series where user defines data range

    Hi I am trying to plot a chart taking data from a single column on another sheet. On the same row as the data item is a date. The user inputs (on the chart sheet) a 'date from' (F3)and a 'date to' (G3)and I want the chart to display only the data between those two input dates. So in the...
  4. S

    Creating user-defined parameter for power query

    Good morning! I created a friendly user dashboard (pivot tables and graphs) based off of millions of rows in power query. My table in power query has the entire universe of data, so when users try to filter for a particular category in the pivot table of the dashboard, they see the entire...
  5. Hobolord

    User defined function not returning desired values

    Hello, I have a PC, Windows 7, and Excel 2013. This is my first time working with a UDF, and I'm sure I've done something wrong... but I have no clue what. The function is supposed to take 3 cells, Year, Job Type, and Margin, and based on the three criteria, the output should be the proper IC...
  6. E

    Introducing User-specified series

    Dear all, I would like to insert the following function in my VBA, but I have no idea if it is even possible, since I just started with VBA. I would like to prompt a message box (or similar) so that the user could insert the "Initial number", the "final number" and the "step". Then, the VBA...
  7. L

    VBA to return LoginID not user name

    Morning All Below is the code I am using to return the full name of the current PC user. I am using this in a selection of workbooks to create user logs, track behavior and speed up data entry. In one project I would like to get the value for the user Login (not name). This is the initial ID...
  8. A

    Current UDF - Compare two text strings make not case senstive

    I use these two UDFS to find the differences between two strings of text, i would be great if they were case insensitive. If anyone knows how to change these ones or has a better UDF for comparing two text strings ( like with options for choosing different / multiple seperators etc that would...
  9. J

    User entry variable date being mysteriously switched around...

    I have a macro that requests the user to input a date. This variable is then used within a filter to select the dates required. The date is entered in UK format and the variable is showing in the Locals window just how the user is inputting the data - as you'd expect. Here's where it gets a...
  10. V

    Keyboard shortcut for highlighting cell

    What is the keyboard shortcut for highlighting cell? Can a frequently-performed task be assigned a keyboard shortcut by user? If it is done by VBA, please post the code. Thanks.
  11. S

    VBA to Sort Protected and Locked worksheet

    I need a VBA macro that will unprotect the worksheet with password prompt the user for one field to sort ascending or descending sort the worksheet protect the worksheet with password exit The worksheet has many calculation fields that are locked and not selectable but a locked field may be...
  12. A

    Insert "X" number of Rows Based on User Input

    Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> Using Excel VBA I am looking to automate a basic Copy and Paste routine which amounts to little more than copying row 3 and then pasting it in the next blank row below.<o:p></o:p> <o:p> </o:p>...
  13. J

    Userdefined Function / Formulae

    Dear Excel Experts- We use SAP system and whenever I copy any data (from SAP) and paste it to excel, it paste it in following format (which is incompatible to sum): 1,468.98 29,463.83 2,281.10- 12,684.40- 64,254.04- So this causes us manually to change it to: 1,468.98 29,463.83...
  14. T

    sendmail for user typed email addresses

    how can i use sendmail where i want the user to type the email address they wish to send the workbook to? if i do it via a form, what will the code be for the send button as the sendmail code i have at the moment is the one where you have to type in the email addresses in the actual code...
  15. M

    Blocking cells for certain users

    Is there any way to block editing cells or columns for certain users? Let's say i want: John to edit column A Peter to edit Column B Peter and John column C. Is this possible? I don't know the information they are entering, so i can't restrict the content, but want to restrict the lines they...
  16. D

    Usually Array Formula but Function needed

    I'm just getting into functions, so please bear with me on this as I start to understand how they really work. I do have the VBA and Macros for MS Excel book which has been a great help! Normally on this I would use a simple array formula to gather a total calculation from a timesheet, but in...

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