I am battling to figure out how to make this easier. I need to take the data from a multi-page of "Comboboxs" and "Textboxs" to a specific sheet. I have code that works, but its going to be a lot of work and I have 2 tabs I have to do this for.
Private Sub CommandButton2_Click()...
Hi,
I have this code for file path for the Invoice PDF.
Private Sub CommandButton1_Click()
Dim NxtRw As Long, CurrentPath As String, wFile As String
On Error GoTo EnEvents
If Range("J3").Value = "" Then
NxtRw = 3
Else
NxtRw = Range("J2").End(xlDown).Offset(1).Row
End If...
Hello,
I have a cell value that I would like as the PDF file name plus today's date included in the name.
For instance:
HAN6597 8/12/2019
Is this possible to do? Also what if the same customer code (in cell H2) and same date are sent to PDF more than once? Does the PDF get replaced or...
Could print to PDF be added to this button?
My print area is B2:H53
Private Sub CommandButton1_Click()
Dim NxtRw As Long
Application.EnableEvents = False
If Range("J3").Value = "" Then
NxtRw = 3
Else
NxtRw = Range("J2").End(xlDown).Offset(1).Row
End If
Range("J"...
Hello, please can you help me with the code below that works great but i just wanted the data in the form to clear once the add button has been pressed and all data has be transferred to the other sheet, is there any way for it to 'Clear' once the button is pressed? please can you help me...
I use the following code to add a date into the first available cell in column S
Private Sub Skip_A_Student_Click() Dim Cnt As Long
Dim NxtRw As Long
NxtRw = Cells(Rows.Count, "S").End(xlUp).Offset(1).Row
Cnt = WorksheetFunction.Count(Range("S2:S" & NxtRw))
Range("S" &...
I am using the below code to cleanup a bunch of workbooks. I came across a workbook that does not have any data inputted below row 1. Row 1 contains the headers. The macro keeps throwing the generic error "Run-time '1004': Application-defined or object-defined error". Clicking the debug issue...
Hey all,
Wondering if anyone can help me.
Basically I have a number of sheets in a workbook that I need my VBA to search through for any rows that contain a date within a range, copy that information and paste it into a specified sheet. I have it working for a single date using VBA but...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.