how to dim userform and then .show object - MrExcel
Mar 26, 2002 · Trying to replace hard coded: USERFORM1.Show with Dim Form as UserForm set Form = USERFORM1 Form.Show VBA crashes at Form.Show with msg: Object doesn't support this …
Global Vs. Public Variable. | MrExcel Message Board
May 24, 2007 · In VBA there are three levels of scope. Local: the variable is declared inside a Sub or Function, using the Dim or Static keyword and is only availible inside that procedure.
VBA - What is 'Dim' used for? | MrExcel Message Board
Nov 3, 2005 · Dim is short for Dimension and is the way in which you define the data type for each variable. Click to expand... So is it a way of telling VBA that you're working with text or numerical …
How do I make reference to a checkbox in VBA? - MrExcel
Sep 28, 2010 · I have a checkbox and I want to basically control whether it's checked or not within VBA. What reference do I need to make? Something xx.Value = True? It's a checkbox created using form …
How can I make Userform's name as a variable to manipulate it?
Mar 21, 2022 · Hi, I am trying to improve the form open events to be placed in the middle of the active screen, but I noticed I have to repeated it thru all Initialize event of each form. This is the code I am …
VBA to create folder and subfolder | MrExcel Message Board
Feb 4, 2010 · Hi, I am using this macro to create a folder, and then two predetermined folders within: Sub MakeFolders() Dim xdir As String Dim fso Dim lstrow As Long Dim i As Long Set fso = …
How To Use Variables Across Multiple Sub Routines (VBA)
Apr 20, 2019 · I was wondering if there was anyway to carry variables across multiple sub routines. What I want to do is set a macro to a button, and I want to use an integer to make small changes to …
Formatting Data to 2 Decimal Places in VBA - MrExcel
Mar 7, 2006 · In my workbook, cells(9,3) = 39.66 The code below is returning facility_1 = 40.00 I need the code to return 39.66 I also attempted to use FormatNumber(cells(9,3),2), which also yielded 40 …
VBA: new 1-D array from selected index on 2-D array - MrExcel
Jul 13, 2015 · Hello all. I'm trying to find an easy way of converting a selected index within a 2-dimensional array into a 1-dimensional array. For example, if I have the...
Dim As Double | MrExcel Message Board
Dec 14, 2002 · Hello All, I once got some code from someone on this board that had Dim as double Dim ty As Double ty = [a65536].End(xlUp).Row What does "As Double" do? thanks, Ima Learnin'