-
Need help to Code VBA using the combination of text and date format
Hi guys! Can you please help to write simple code in VBA so it will contain the following (in Excel in one line combine text and current date). Example: in Excel i expect to see the following =IF(A28="","","Processed(current date)")
I have this below written in VBA:
sFormula4 = "=IF(A27=" & Chr(34) & "" & Chr(34) & "," & Chr(34) & "" & Chr(34) & "," & Chr(34) & "Processed" & Chr(34) & ")"
My question: how to write code so it will add current date after word Processed? Format mmddyyyy, so it will look like Processed06182020.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules