vbnewline

Hello and thank you for any attention my post may receive. I have a userform (frmCalendar) which appears when I click a specific cell (C4) on a worksheet (Scorecard). The problem I have is that when I close the worksheet through a 'Save' command button and selecting 'Yes' in the message box...

Hello, Im wondering why my .SetFocus is not working properly In the code below i have if the user does not input a valid date, clear the box then i want to setfocus back into that textbox, but what it does is it DOES clear out the textbox but then it just jumps ahead to my next Tab Index...

Good Day All I add Space After < to be posted as code So please Ctrl + H and replace "< " with "<" to remove Space My Problem is if Cells Merged or after Hidden Cells lost some side border color

Hello, I am using Ron debruin's PDF to Email add-in and it has been working perfectly for the past few years, however as of today, i am receiving this error: Not possible to create the PDF, Possible reasons: Microsoft add in is not installed you cancelled the getsaveasfilename dialog the path...

So i'm trying to find the row number of the value "period" and i don't know how to get the correct row number in which the value of "period" is in. Right now the value of "period" is taken as the row number, so when the msgbox pops up it shows the wrong information. This is what my sub looks...

i have this code: Public Sub pdfopslag() Dim myCell As Range Dim valRules As Range path = Range("I21").Text Set valRules = Evaluate(Range("A9").Validation.Formula1) Application.ScreenUpdating = True...

Hey folks, I'm trying to figure out how to add text at the beginning of a ReplyAll email. When the first .Display runs, the .ReplyAll is good (however, the new text hasn't been added yet). However, when I try to add to the .Body, the original email text is deleted and I'm left with the new...

Hey all, I created a script that will auto-generate an email in outlook based upon a cell value in a row, and will populate the email based upon information in that same row. Long story short, I would like to be able to apply this to all rows, or at least to a defined set, and if possible, all...

Good day code below was summarized I use it to create html file then convert it to word document from Excel how to get like below code full for html document and < o:DocumentProperties> ?Please remove Space after "< Public Sub Html() Dim StrHtm As String StrHtm = "< html...

I have the foliowing snippet of code to email data I need it amended to include the value of B1 on sheet "Ageing" after the text in my code "Please attend to those over 60 days" strBody = strBody & "Attached Please find Debtors Report-Please attend to those over 60 days -Please chase up on...

Good afternoon everyone, I got some code that will automatically send an email based upon cell value. I got the To and CC fields right, but I cannot get the From field to send from the right mailbox/distro. Anyone know how I can do this? Private Sub Worksheet_Change(ByVal Target As Range)...

Been Looking around a way to avoid using HTMLbody as at work we have different signatures with different images and disclaimers. Everyone has their own signature set up using outlooks default tool. Is there anyway I can get the users own default signature added to this code in outlook without...

Could I please get help simplifying (if possible) the message box. Currently, the message box pops at the end of the code and displays the following when it finds a duplicate in a row between range B and K. cell.address and cell.value cell.address and cell.value And repeats any duplicate...

Hey Everyone! Can't seem to figure this one out for the life of me. I click submit, an e-mail is generated, the macro takes value's from text boxes in user form to create the "To", "Subject" & "Body" fields, but I also need it to attach the file listed in the PO text box (txtsspo.value). I've...

Hi, I have a VBA which takes the current worksheet and emails it out (code shown below). However in the new file it creates and attaches to the email, the colours are distorted and not the same as the original worksheet. Does anybody know how to prevent this from happening. Many thanks Sub...

Hi, I have a sheet I have been working on for a while that I have pretty much got to do what I need it to do more by luck than judgement sometimes. what I need to do now is really causing me a problem. When I enter data via a userform it produces an email with the appropriate data on it, what...

Hi, I am very new to VBA Code and am struggling to achieve adding an Excel 2010 workbook (or even Active Worksheet) to an e-mail using VBA and wondered if anyone could help? So I've created a form in Excel 2010 which I want colleagues to complete. When they've done that, I'd like them to be...

I'm trying to find to get a series of values in a MsgBox if criteria is met. If the value in Column F is 'Overdue' I need values from the same row populated in a Msgbox then a newline and then the next row of data that matches the criteria, so I would end up with 1 message with the values from...

what wrong I have Public Sub Creat() Dim docPropsXML As String Dim docPropsFolder As String 'Creating the Document Properties FilePath = ThisWorkbook.Path & "\" RootFolder = FilePath & "root" docPropsFolder = RootFolder & "\" & "docProps" If Len(Dir(RootFolder, vbDirectory)) = 0 Then...

Hello, I've been searching the forum to help me with my problem. I've managed to put a code together using the tips I have found on the forum. However, if I continue working the message keeps popping up. How do I make it stop? Thanks in advance. Private Sub Worksheet_Change(ByVal Target As...