This is an esoteric OOP concept and there’s a little more you need to do and understand to use a custom collection of shapes. You may first want to go through this answer to get a general understanding of classes and interfaces in VBA. Follow the below instructions First open Notepad and copy-paste the below …
Try using an X-Y Scatter graph with datetime formatted as YYYY-MM-DD HH:MM. This provides a reasonable graph for me (using Excel 2010).
This question was answered well at Can you encode CR/LF in into CSV files?. Consider also reverse engineering multiple lines in Excel. To embed a newline in an Excel cell, press Alt+Enter. Then save the file as a .csv. You’ll see that the double-quotes start on one line and each new line in the file …
From other forums, I have learned that it is due to the MS Update and that a good fix is to simply delete the file MSForms.exd from any Temp subfolder in the user’s profile. For instance: C:\Users\[user.name]\AppData\Local\Temp\Excel8.0\MSForms.exd C:\Users\[user.name]\AppData\Local\Temp\VBE\MSForms.exd C:\Users\[user.name]\AppData\Local\Temp\Word8.0\MSForms.exd Of course the application (Excel, Word…) must be closed in order to delete this file.
No, but you can create a naive one simply enough by adding the following to a VBA module: Public Function printf(ByVal mask As String, ParamArray tokens()) As String Dim i As Long For i = 0 To ubound(tokens) mask = replace$(mask, “{” & i & “}”, tokens(i)) Next printf = mask End Function … =printf(“Some …
Unfortunately there is only the function setColumnWidth(int columnIndex, int width) from class Sheet; in which width is a number of characters in the standard font (first font in the workbook) if your fonts are changing you cannot use it. There is explained how to calculate the width in function of a font size. The formula …
I also had an issue with this problem simply copy and pasting DATETIME fields from SQL Management Studio to Excel for manipulation. Excel has the correct value of the DATETIME (even if the formatting is applied after the paste), but by default doesn’t have a built in format to show the SQL DATETIME. Here’s the …
Posting a response so I can mark my own “question” as having an answer. I’ve seen other workarounds, but this seems simpler and I’m surprised it works at all. Sub ChangeIt(c1 As Range, c2 As Range) c1.Value = c2.Value c1.Interior.Color = IIf(c1.Value > 10, vbRed, vbYellow) End Sub ‘######## run as a UDF, this actually …
To answer your direct question, it is: Range(“A1”).NumberFormat = “@” Or Cells(1,1).NumberFormat = “@” However, I suggest changing the format to what you actually want displayed. This allows you to retain the data type in the cell and easily use cell formulas to manipulate the data.
As of modern version of Excel, there’s the syntax with commas, not semicolons. I’m posting this answer for convenience of others so they don’t have to replace the strings- We’re all lazy… hrmp… human, right? =CONCATENATE(DEC2HEX(RANDBETWEEN(0,4294967295),8),”-“,DEC2HEX(RANDBETWEEN(0,65535),4),”-“,DEC2HEX(RANDBETWEEN(0,65535),4),”-“,DEC2HEX(RANDBETWEEN(0,65535),4),”-“,DEC2HEX(RANDBETWEEN(0,4294967295),8),DEC2HEX(RANDBETWEEN(0,65535),4)) Or, if you like me dislike when a guid screams and shouts and you, we can go lower-cased like …