vba excel

  1. C

    VBA dates

    Hello! I am new to VBA excel and i have a homework where i have years from 2000 to 2030 and i have to find Advent 1st for each year. Can anyone help with this? Thank you!
  2. dss28

    to do list in calender

    I have designed a calender with a to do list in which each row is assigned for to do list serial no. and columns have dates. when a cell is clicked it opens a userform1 with 4-5 textboxes/ comboboxes, which now at present is filled manually by selecting the particular row and date column. The...
  3. dss28

    Identify row number of the data in a listbox

    I have a listbox which is filled with data transferred from textboxes in the userform and not from sheet. The listbox has multiple rows and columns. I have also added a code to delete a row before final saving of the data to excel sheet. Hence if I try to give / add a row number through a...
  4. dss28

    Capturing data in rows for number of days selected in calender

    I want to build a data base using a userform1 having say 4 textboxes to input data textbox1 - Name textbox2 - address textbox3 - Start date textbox4 - end date the sheet1 where data will be saved will have columnsA as Name, ColumnB as Address, ColumnC as Date. I want to capture data in sheet1...
  5. A

    VBA for Merge and Center Dates based on condition met.

    I do a LOT of scheduling people at my job. Kronos spits a nasty excel sheet with 1000's of rows and about 40 columns. I've got created enough macros to where it fine tunes it to what you see below BUT I would like to do a few more things to really make it so I can print these schedules for staff...
  6. U

    VBA: Open Password protected file in Excel

    Hello Gurus, Basically, I need to open password protected PDF file even on read-only. I found this code online and wanted to ask if you can help to update the code. = = = = Sub Workbook_Open() Application.DisplayAlerts = False 'Change 1234 to your file password accordingly Dim pdfPath As...
  7. E

    Summation based on each chunk(blank cells)

    I would like to do sum based on each chunk, my code is taking the whole column instead. I can't figure how to write a loop that stops at the blank cells. Sub Button9_Click() Dim LR As Long LR = Range("L" & Rows.Count).End(xlUp).row Range("N2:N" & LR).Formula = "=L2/SUM(L2:L" & LR & ")" End Sub
  8. D

    using a header as an identifier for an input range

    Hello using VBA, i am wondering if this is possible. I have a cell that is a header, to be an identifier i guess you could say. So i have batches and inside i want entries starting at cell A51 that contains the words "Schedule A" and I have data points that I want to copy from that section of...
  9. D

    Error when using GetOpenFileName vba

    Using VBA, how can i edit this code. I have a cell in sheet called "file paths", in that cell is the exact file path of an xlsm file. I am trying to use GetOpenFilename and use that string that is in the file path cell the file path in that cell is: C:\Users\ThisPc\Desktop\Book1.xlsm Code: Sub...
  10. H

    Putting VBA code to prompt to open a file

    Hi Friends, This is Captain H from Saudi Arabia, I am a newbie in VBA excel and was seeking to get a solution as to what code can get the system to ask me what file to open in the external link in VBA excel. Please if someone can help me, would really appreciate it.
  11. W

    Vba to include values of specific cells selection to the subject of outlook mail

    I select data from excel workbook and send to outlook. I need to update the below Vba code to include values of specific cells in columns (F,G,H) corresponding to my selection to be in Subject of Email , but I do not know how ! For example: Work orders need review @” ……… , …………, …………. [![Sheet...
  12. Y

    [vba] Pull Data from a Specific Sheet in another Workbook

    I get this code from this site: Excel Macro to Pull Data from another Workbook Option Explicit Private Sub CommandButton1_Click() ' Create and set the file dialog object. Dim fd As Office.FileDialog Set fd = Application.FileDialog(msoFileDialogFilePicker) With fd...
  13. N

    How to keep the validation List available even after paste

    I have a cell has a list countries , when I paste data, this cell will have a new information but the list will be disappeared ! how can I keep the country List available even after paste . Regards
  14. E

    Run a Macro based on a cell value

    I have a summary tab where i want to run macros depending on what is selected in a drop down list to compare two other data tabs. The data tabs are called 'A', 'B', 'C', 'D', 'E' and 'F', and the data in each tab is in the same cells and format, just different values. I want to have two drop...
  15. E

    Format the selected series in Chart in Powerpoint

    I would like to create the macro which will format the selected "DATA LABELS" in chart in powerpoint. Below is my code. But the problem is Im not able to write code for selected "Data Labels". Please assist Sub testSelection2() Dim shp As Shape Dim count As Integer Dim left_count As Double...
  16. M

    Copied Date Data is NOT a Number

    Hi, How do I copy date data retaining its number format? Dim Sourceworkbook1 As Workbook Set Sourceworkbook1 = Workbooks.Open("[File path & name]") Application.ScreenUpdating = False Sourceworkbook1.Sheets("[tab name]").Copy After:=ThisWorkbook.Sheets("[tabname]") I have written a matching...
  17. Z

    Copy and paste

    Hello, I am trying to copy a block of lines (the red one for ex) from a source sheet to another sheet using a button to show a userform and then choose specific elements. The source data are: Well, in my userform I have to choose the test, number of test, Week and year: and then the...
  18. L

    VBA Excel, group rows and perform an action for each group

    Hello! I have an excel like this: So I have column A, I want column B to complete automatically. I though that by entering a blank row between groups it will be easier to separate groups. So it will go down the column A and for each not empty row it will write Iph in column B, when it finds...
  19. S

    Copy Specific Sheet of multiple workbook to multiple sheets of another workbook

    The below VBA code breaks if the name of the workbook or there is no workbook exist. In my case, the VBA code breaks on opening workbook wbR4 due to difference in name and the code stops there itself and not proceeds to next workbook. The code is about to copy specific sheet of source workbook...
  20. Z

    Duplicates items in a listbox

    Hello, I am new in VBA programming, I have data on an excel worksheet in column A cells(23,i) and A celles(24,i) ordered like this I want to show the data in a listbox without duplicates and showing only recent dates for each value (N IT) like this: To show the list I created a button, and...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

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.
Go back