populate

  1. S

    Userform Combibox (dropdown) box populating

    Good Morning, I've got a data array, which my userform combibox/dropdown menu references. I have 100 available "slots" for data input in the array, but I don't use all of them. The initialize code (below) works well for the combibox to populate it. However, being as I only use about 20 of...
  2. S

    auto populate

    ok, i'll explain as best I can in d2:s2 I have week numbers in a3:a100 I have part numbers what I am looking to achieve is if I populate (as an example) h15 a formula in c15 will populate with the relevant week number from row 2
  3. A

    Populate Range from string

    I'm passing a Range to my Form via a Property Dim Rng as Range Public Property Let rRange(z as Range) Set Rng= z End Property Then I attempt to populate that range (which is a single cell) Private Sub cmdApply_Click() Worksheets("Sheet1").Range(rng).Value = Me.txtTest End Sub I get error 1004...
  4. M

    Auto populate with data validation

    Hi all, can't seem to figure out an issue. I have data is cell A1 but want it to populate the next 2 cells only. Then the user will have to select data from a drop down list on the next cell following the 2 cells. Example : Colors: Green,Yellow,Red Drop down selection: Free,Green,Yellow,Red...
  5. L

    How to populate a cell[s] by clicking on another cell

    Hi all, 1st post here. I want to cells to populate with "Y" when someone clicks on another cell in a worksheet. Is this possible within excel? If so, could someone assist. Example, someone clicks on cell A1 then cells A2, A3, A4, A5 etc. are populated with Y. Thanks.
  6. A

    VBA Syntax For Dynamic Formula Statement For a Range of Cells

    Hello, I am struggling with the syntax of the following line in red ... With ws_srcdata src_lrow = .Cells(Rows.Count, 7).End(xlUp).Row src_rowcnt = src_lrow - 1 'populate calculated columns For r = 2 To src_lrow 'Z - Net Use Hours...
  7. S

    Populate rest of Userform based on two ComoboBox Values

    Hey all, I am trying to quickly get order data from a single sheet of over 3000 entries using a UserForm to make it as simple as possible for staff. So far i've made a userform that i want to use containing a number of text boxes: "Cust ID", "Order #", "Item", "Part No", "Date Ordered"...
  8. S

    Populate Outlook Userform Listbox From Excel Data Table

    Hi Guys, I know how to populate a Userform Listbox from within excel, but I want to create a listbox in Outlook to be populated from data in the first column of an Excel table. At the moment I have this from within Excel: Me.ListBox1.List =...
  9. P

    runtime error '380 Could not set the rowsource property. Invalid property value

    Private Sub UserForm_Initialize() ComboBox1.Value = "Please Select an employee from the dropdown" ComboBox1.RowSource = "Sheet1!A3:A" & Range("A" & Rows.Count).End(xlUp).Row End Sub Why won't this code populate my combobox? It worked for the person in the YouTube video. Thank You
  10. J

    Email 'Do It All Super' Button

    Hello! I would like to send an email from excel that has a pre-populated body of text that but also pulls some data from an excel sheet to populate parts of the email. So for example, you would click the macro....a prompt would ask for a row number and based on that, the email box would pop...
  11. J

    Referencing columns by number in macro?

    Hi, I'm looking to pull the contents of multiple workbooks into one, and found this old thread, the first reply works perfectly: https://www.mrexcel.com/forum/excel-questions/818972-macro-pull-all-data-every-file-folder-copy-data-into-open-workbook.html However, that macro populates the...
  12. N

    Dynamic Slicer from pivot table

    I have a pivot table and I wish to be able to make a slicer and in another list select the column that will populate the slicer. right now I have a test table, that I will leave in the description. I have 4 columns, and I wish to be able to select the column name in a list and that will populate...
  13. M

    Populate textbox dependent on combobox value

    Hi There, I have no idea where to start with this so would love some help. I have four comboboxes with twelve colours on the list (each has an identical list). Say the colour "Red" is selected in the combobox i want the textbox to populate with information which corresponds to the Value "Red"...
  14. M

    Dynamic ListBox for an invoice

    Hello Everybody, I woud lile your help on some issues i'm facing when i try to populate a combobox from a specific range based on a certain condition. Below is a listbox i created that provides the summary of all the invoices registered (see image below as an example): When i select an i...
  15. B

    Array: how to populate it starting from a cell's value up to zero

    Hello, I am new to arrays and am really struggling with the concept. Here is what I am trying to achieve: in range("B3:B9") I have some numeric values. Let's say that the value in B3 is 37: I would like to create an array that contains all values from 0 up to 37 based to an incremental...
  16. T

    Need to changed the value in a cell based on another cell with multiple values options

    I need aformula that will auto populate like this: If A1 shows “M”,then auto populate in A2 “T”, or “T” , “W”, or “Th”, “F”, and so on. I was tryingto write an “IF” statement, and then a VLOOKUP, but I am not good at writingthese formulas. Could anyone assist in helping write this. I...
  17. M

    MACRO button to fill headers

    Hello, I have a workbook in which I would like to have some headers populated by simply filling in some cells with text then hitting a macro button to populate the headers of multiple sheets automatically. The headers already have some text in them which need to remain. i have snip images of...
  18. L

    IF formula output not expected

    I am using 2 embedded IF statements in the attempt to produce either a string (cell&cell...) or a string with -SPARE are the end. I know the inner IF statement works as expected. The result is setup to work on the FALSE, not TRUE for desired output. My outer IF works when I do not include the...
  19. A

    populate cells using

    Hi, I've been trying unsuccessfully to populate a table (T2) with info from a table (T1), perhaps using an 'x' or 'y' to show which student is on which course. T1 is: <tbody> StudentID Course a1 French a2 Math a3 English a4 Science a5 French a6 English a1 Science a3 French...
  20. D

    Vlookup to return the nth value.

    This is my formula that returns the 1st value but I need to return the data from the 2nd and so on. My project is to pull data to populate invoices based on the invoice number. =VLOOKUP(value(rngInvoice),Received_Process, 2,false)

Some videos you may like

This Week's Hot Topics

Top