vba & excel & forms

i found this code for master DanteAmor https://www.mrexcel.com/board/threads/combining-data-in-listbox-on-userform-across-multiple-sheets-and-calculate-values-amongst-them.1182427/page-2#post-5758315 and i try modifay it to suitable for me but its not appear all item in column 8 when the...

I have a column B that contains the date, and a column "i" that contains incoming values, a column" j "that contains spent values, and a textbox1 contains a date and a Textbox 2 is required to show the result of collecting column cells, "i". that are smaller than the date in textbox 1, as well...

HI All. I am trying to add a user form to an excel data table with formulas, I have managed to get the user form to add the data to the table, however it keeps over writing the data on the first row of the data table and not inputting it on there next available row, Can you please help me with...

Situation: I have a VBA program that builds a new compilation workbook from other Excel files. The new workbook contains some forms objects / event handlers and is saved "WBout.Close SaveChanges:=True" in a ".xlsm" file. The program works flawlessly when I execute on my home Win10 PC with...

Please Help I am a VBA / Macro novice.... I have an excel spreadsheet with column and row headers that is filled out using drop down boxes and check boxes and text boxes (that is as advanced as I get !) What I need it to do is to be able to fill this form out daily, and then overnight the form...

Hi I am totally new to Ms access and apparently I have been using the wrong application(Excel) to build my databases lol better late then never so far I have learned the basics of creating both tables and form but am having issues when importing new data. I am trying to import new data from an...

0 1 I have a link to options in Think or Swim I have a form that I'm using to enter values into this sheet and for the textbox "tbossot" I'm using this code to copy to the worksheet: Cells(lrow + 1, "R").Formula = "='" & tbossot.Value & "'!" but when I paste this link into my form, it gets...

Hello everyone, I want to copy paste data from multiple workbook to single workbook. I have created sheet names Master Macro and in the sheet3 i have mentioned the names of the files(which is usually our employee names). VBA should go to the folder and fetch data from a sheet named "Rawdata"...

I've been trying to put this one together, but no success so far. Option Explicit Public Sub listBoxPopulate() Dim data As Date Dim BB As String Dim CC As String Dim DD As Date Dim DateVal As Date TBL = Worksheets("PartsData").Range("A1:C100") DateVal = Selection.Value UserForm1.ListBox1.Clear...

Hi every one. I am trying to print labels from different ranges in a sheet ("Etiquetas") with different amount of copies per label from another sheet ("Rangos"). I get to print the labels but individually not by the different quantities in the "Rangos" sheet. The printer is a Zebra model...

Hi, I've tried various ways but nothing seems to work for the code I have. The below code allows me to add data to a new row from UserForm1. I need assistance with changing the code so that I can select the row which will populate the UserForm and allow me to amend/update the data. The code...

Hello all, I'm not sure is this is possible, everything I have looked at seems like it needs to be exact amount. I'm hoping someone can help. Please see image attached. In column B is the list of amounts I want to seperate into C D E F G columns. The total of £189,733.00 is divide by K6...

Dear all, I am currently having some issues with a mix of IFERROR, INDEX, MATCH and TRANSPOSE and ROWS formula in Excel: I have the current sheet of data: The formula and the data links to this test sheet of data: Now I have done about 90% of the work (I hope), seen as my...

I have a Userform that is opened by worksheet change event: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("E4")) Is Nothing Then Load frmActions frmActions.Show End If End Sub The form has various checkboxes in it...

I'm trying to close a user form with a button. On button click I get "Argument not optional" error - I have no idea why? Any advice would be appreciated. Private Sub cmdOK_Click() Unload.Me End Sub

In my worksheet I have a drop down list in D4 and in E4 I have a XLOOKUP formula with the lookup value being the value in D4. I want a user form to show when the value in E4 changes, however I cannot get my code to work for me. Private Sub Worksheet_Change(ByVal Target As Range) If Not...

I got data in sheet1 and sheet2, which i want to copy and paste in sheet3. That is already done. So next i want to match rows, by checking column C, D, E, H and I. The C and H column value is integer and the rest is text/strings. If two rows match, then i want to copy and paste one of the lines...

Hello All, I'm developing a dynamic bucket wise OS report maker from Ageing report wherein users enter the days through form and by clicking the button "Make Bucketwise", the Bucketwise OS report will be generated (adjacent to the Ageing report) as per the days provided by users. Here users may...

Hello, i would like to make a data input from two workbooks that is in the same path. The data input should be in the master workbook from those two files. The first sheet in the master workbook should just be empty as im going to make macro run buttons for later purpose. The data from the first...

Hello everyone I would love some help to develop some VBA code. But im very new to VBA. Hope someone can help me with it, and i know its a lot to implement. So its for private purpose and a "just for fun project". The project is that i want to two files in a path that i want to match with...