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...
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...
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...
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...
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.
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
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.
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...
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...
change rows to columns
column appearance change
formula = concatenate
index & match
transpose & index
transpose & match
transpose column to row
vba & add
vba & excel & forms
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
The form has various checkboxes in it...
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)
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...
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...
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...
The code below here was written for me by @Fluff some time ago. It's a very wonderful code and I love it.
I have added 2 more comboboxes to use as the criteria for doing my filtering but I am stacked with how to get it tweaked.
The new comboboxes are:
ComboBox3, which will check column Y and...
This workbook works fine for me but if somebody else uses the workbook it says "Can`t Find Project or Libary". When they press update on a user form?
It`s on our server so should work for all of us?
My Manager needs to see it today so somebody please help