Issue So I have a spreadsheet with a bunch of sheets that list names in the first column. On one sheet, the Input sheet, I have a command button that opens a Sub that prompts the user to perform a
Continue readingTag: vba
[SOLVED] Simplify vba code with lots of repetitive operations
Issue I’ve created a userform with a large number of textboxes and tick boxes. When the userform is initialised, data is loaded into the textboxes and the tick box values are defined by values specified in one of the workbook
Continue reading[SOLVED] How can I populate data once it is within a window of time?
Issue I would like cell J25 to display certain data when it is the next task in the schedule (please see below data). The next task on the sheet ROUTINE should populate into J25 in relation to the time in
Continue reading[SOLVED] How to include more than one column within CurrentRegion?
Issue Range("A1").CurrentRegion.Columns(2) I understand that this selects column B. How would I set it to column A and B? I’ve tried 1, 2 and 1:2 and neither work. Thanks. Solution If you want to get columns A:B applied to CurrentRegion,
Continue reading[SOLVED] VBA how to find a folder name which is include Today's date
Issue I need to check if there is a folder which name is include Today’s date. This is the path looks like; B:\NOS\EIhracat\Credit\2022\34- 17.09.2022\Nakit List.xlsx But I have a problem about folder names. There are a lot of subfolder looks
Continue reading[SOLVED] Multiple Worksheet_Change events in VBA code
Issue I want to merge two Worksheet_Change events. The aim of the code is to convert any uppercase text in the cell ranges given to lowercase. I tried copying both into the same Worksheet_Change, but Excel crashed. Range 1: Private
Continue reading[SOLVED] How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
Issue How can I use regular expressions in Excel and take advantage of Excel’s powerful grid-like setup for data manipulation? In-cell function to return a matched pattern or replaced value in a string. Sub to loop through a column of
Continue reading[SOLVED] How to filter columns when adding data into MS Access using DoCmd.TransferSpreadsheet?
Issue I have an excel file with two sheets. The first one I want to add the entire sheet to an MS Access table – and so far this code is accomplishing that. But with the second sheet (sheet2) I
Continue reading[SOLVED] How to add blank line in email body?
Issue I want to update email body but entire body is coming in one line. How to add blank line in email body like below? Dear Kalpesh, Your enthusiasm and ability to demonstrate & deliver your set goals has resulted
Continue reading[SOLVED] Send emails using VBA from Excel sheet with multiple recipients – pull in date and attachment
Issue I am using VBA code to send emails from an Excel sheet: Example Excel Sheet I use code to generate a separate email for each email address in Column C with a file attached. My code is below. I
Continue reading