What do you want to save?
Add Code snippet
New code examples in category VBA
-
Matt Campbell 2021-09-06 14:32:02
how to convert weeks to days into textbox with VB site:stackoverflow.com
'TextBox1 is where the user inputs the number of minutes Private Sub TextBox1_TextChanged(sender As Object, e As EventArgs) Handles TextBox1.TextChanged Dim d = TimeSpan.FromMinutes(TextBox1.Text) 'creates a TimeSpan based on user input, this is also ... Add solution -
Gogehat 2021-09-06 13:27:02
excel vba highlight cells using the hex color value within the cells
'VBA function to color cells in selected range based on the hex 'color number entered in each cell. For example, #FF69B4 Sub ColorCellsByHex() Dim r If TypeName(Selection) <> "Range" Then Exit Sub For Each r In Selection ... Add solution -
-
Lion share 2021-09-06 05:19:02
programmatically copy data from one workshet to another excel
'This essientally clones the "Source" worksheet ExcelWorkBook.Sheets("Source").Copy(After:=ExcelWorkBook.Sheets("LocationSheet")) ExcelWorkBook.Sheets(ExcelWorkBook.Sheets.Count).Name = "NewSheetName" Add solution -
Hyrum Tanner 2021-09-06 00:55:01
excelvba quotes in string
'Including double-quote characters in VBA string literals can be confusing. 'First, realize that VBA (unlike many languages) does not recognize the 'apostrophe as a quotation mark. In JavaScript, for example you can simply 'do this: ' var s = 'The "... Add solution -