vbcrlf

Hi Guys, I'm setting up an email template using some VBA where the following in displayed in the email: Range("B11").Value & " " & Range("C11").Value & vbCrLf & _ Range("B12").Value & " " & Range("C12").Value & vbCrLf & _ Range("B13").Value & " " & Range("C13").Value & vbCrLf...

The following cell provides a pop up message when NO is entered in cell H5. Private Sub Worksheet_Change(ByVal Target As Range) If Range("H5") = "No" Then MsgBox "If there is pink in a previously filled cell, after checking No." & vbCrLf & _ "There is Scheduling conflict." & vbCrLf & _ "Choose...

Hi All, I am using the following Macro to check due dates and create and send emails based on due dates. I am in need of one last piece to finalize this, and that would be: if range is "complete" do next row. That meaning if the task is complete, it would skip that row and go to the next task...

Is it possible to line feed in a function? Like after results vbCrLf Something like "Washington" & vbCrLf & "Lincoln" & vbCrLf & "Columbus" & "Johnson" & vbCrLf & "Roosevelt" Function PopDen(s As String) As String Select Case Trim(s) Case "06554", 6554: PopDen = "Washington...

I have a btnclick event that adds a combobox to a userform. This works fine. I have it set the left, top, width, font.color, font.italic and font.text attributes - It all works good. Here is that code... strComboBox = "Forms.ComboBox.1" strTextBox = "Forms.TextBox.1" strLabel = "Forms.Label.1"...

Hello, I've have code that creates a PDF from my workbook and this saves the PDF to a folder based on a cell (Menu Sheet A5). This cell is change via a drop down list, so I can change the location of where the PDF is saved to. This issue I have, is someone has change the structure of our...

Hello everyone, Hope everyone had a merry Christmas and are still in a good mood for the New Year :-) I put together a code, because I'm not a big light of VBA I have the principle Copy / Paste applied. Try to insert in my code the desired areas I would like to copy, without much...

I have a save button that's supposed to save a file and then, based on the name of the file, delete the old copy. When I originally had the coding set to send a msgbox about where it was being saved, the button worked. Then I changed the coding to a yesno msgbox and I added the kill piece for...

Dear, I would like my Excel worksheet to be sent by email (as pdf) by running a macro. I am using the below mentioned script. However, I would like to edit the script so that the file name is saved as a specific cell within the current sheet (for example F2) instead of the worksheet name, and...

Hi, When I run this code. My aim is to have a user be able to pull data based on their selected criteria from the inputbox from a closed file (which isn't going to be opened). That closed file is updated (with a new file name) each week, hence the user having to select the file initially to...

Hi everyone. Would appreciate your assistance if possible. I am using sendkeys to mitigate a data entry process. I found the code below and had some success with being able to send keys. I have data in Column A, and some of the values are static whilst others are filled dynamically. How do...

Hi, I have a macro that was written for me some years back by a user, that scraped data from a website. It is now in need of updating as the website has updated/changed a little. basically i get sports results and fixtures from the website, usually 2 or 3 times per week. It was set up so that i...

I have been working on a VBA project that was created by another user, which has involved correcting many minor errors (mainly undeclared variables, etc.). I have worked everything out for the most part, except for the following section. I get the 'Object or Library no found' error, as you do...

Hi All, Please help me with this error (Run-time 1004) that comes up each time I run this code. Sub Saveaspdfandsend() Dim xSht1 As Worksheet Dim xSht As Range Dim xFileDlg As FileDialog Dim xFolder As String Dim xYesorNo As Integer Dim xOutlookObj As Object Dim xEmailObj As Object Dim...

Hi I hvee cdebelow and whee the text isfor forward plaaning I wantthis tohave a text highlight color of yellow please an you advise ow t do this? many thanks for your time "<br><br>" & "Forward Planning & JM-ing - ??." & "<br><br>" & "Many thanks, New Connections Team." Private Sub...

Guys I would like assistance from you to develop a function that will create a dinamically SQL Union Statement I have an excel table containing on column 'C' the Server Name and on Column 'D' the data base name. The Column 'E' contains the current status of the Servers (0-Offline, 1-Online) I...

HI i have encountered this below error. i have for example 5 email id, name and attachment path in excel file. i want to send email to them with attachment . this below code does not pick up attachment . Please guide me Set OutApp = CreateObject("Outlook.Application") Set OutMail =...

I have a sub which loads a splash screen. very basic. For some reason the first time I load the workbook it doesnt fire. If I close it then open it it does. Then if I restart my comp and load it again it doesnt fire. Any ideas why? Private Sub Workbook_Open() 'error 438 somewhere in here...

Hello everyone, At work I have inherited an Excel employee training database. The details of an employee are entered into a user form and can be edited/updated or deleted. The issue I have is that when you go to delete an employee completely, you have to select the employee from the listbox of...

I get an 'The operation failed' error message in the line in red below. At one point i restarted my PC and it all worked, but now it has come back again. Has anyone ever come across this issue? For Each cell In Range("A3:A" & intLastFilteredRow).SpecialCells(xlCellTypeVisible).Cells...