What do you want to save?
Add Code snippet
New code examples
-
VBA 2022-02-03 07:21:40
excel vba translate to english from french
'Here is a VBA User Defined Function to translate text in an Excel cell. It 'uitlizes Google Translate and thus requires an Internet connection: Function Translate$(sText$, FromLang$, ToLang$) Dim p1&, p2&, url$, resp$ Const DIV_RESULT$ ... Add solution -
VBA 2022-02-03 02:21:53
vba initialize or detect NaN infinity infinity special values
'VBA function to create and detect IEEE 754 Floating-Point Arithmetic 'special values in the Double data type. 'To create a special value: MsgBox SpecialVal("PosQNaN") 'displays: 1.#QNAN MsgBox SpecialVal("NegMin") 'displays: -1.... Add solution -
VBA 2022-02-02 23:16:28
vba global vs public
'In VBA, GLOBAL variables must be declared ABOVE all procedures in a module: Public MyGlobalString As String '<-- global to ALL modules Private MyGlobalLong As Long '<-- global to THIS module (Private) Public Const HELP As String = "Pres... Add solution -
VBA 2022-02-02 13:45:59
excel vba check if key is in collection
'A Dictionary is a better choice when you need to determine if a key 'is already in the collection. But here is a VBA function that 'reports True or False for Collections: Function KeyExists(key$, c As Collection) On Error Resume Next c.Item key K... Add solution -
VBA 2022-01-31 05:20:40
excel vba date to string conversion
Excel formula to turn a date/time into text: =TEXT(A1,"DD/MM/YYYY hh:mm:ss AM/PM") 'Reference: ' https://support.office.com/en-us/article/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c '---------------------------------------------------... Add solution -
Other 2022-01-30 21:15:10
client side validation mvc tutorialsteacher
<!DOCTYPE html> <html> <head> <meta charset="utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>@ViewBag.Title - My ASP.NET Application</... Add solution -
VBA 2022-01-30 19:50:10
vba default border
' VBA ONLY '=============================================================================== '>> SelectedCellsBordersForceDefault '=============================================================================== ' Makes all the borders of the selecte... Add solution
Best helpers
Rlw
+5
John Rualo
+5
Michael Wang
+5
Heavens
+5
Calvino
+5
Withparadox2
+5
SuzyTypehead
+5
Aj Morales
+5