Hello. When developing, I have found it convenient to use TempVars because they maintain state even when my VBA project does not. In addition, I don't have to run a load procedure every time I restart my code.
To provide a bit of validation and intellisense, I wrap them in properties in a...
There is a button click private sub on another sheet, I just want to invoke it from a macro. The below doesn't work:
CallByName Sheet30, CommandButton10_Click, VbMethod
Is there a better approach?
I have a userform that during run time creates 256 individual labels (they represent 5 charts with 53 weeks of data).
This works great, I move the axis and scale as needed, I color code them based upon data in the spreadsheets, they have control tips to show their full value.s
I also have...
I'm struggling for a while with a generic mechanism to assign some short-cuts to methods that are implemented in classes. This is what I have so far:
In a class module ("test2"):
Private Sub Class_Initialize()
Dim var(0 To 1) As Variant
var(0) = 5
var(1) = "ThisIsAstring"...
This might be a ridiculous want but I'll ask anyway. I'd like to be able to create a number of variables based on user input. Something like this:
Dim Counter as long
Dim X as long
X = inputbox(prompt:="Enter Number of Blah Blah")
For Counter = 1 to X
I have a VBA Routine where I open workbook and run some code in the newly opened workbook that requires two input parameters...I've been trying to pass them ByVal however the debugger now does not recognize the Call to the procedure if I include the variables...anybody have any ideas on...
I have a string variable which I have succesfully passed to a sub in a userform. The variable is used to call a second userform from the one it was passed into. My problem is that I have no idea how to execute the %^&$ thing.
Suppose I have a variable
MyVar = "MyName"