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...
I've finally got everything working how I need it to (thanks to the people on here!) and now I'm at the last hurdle.
From my Dashboard sheet, I then want to select each sheet and run the necessary macro. Once done, it takes me back to the Dashboard.
The problem with my code below, is that if...
I am trying to get a macro to autorun when I open a workbook.
I want this macro to run automatically as soon as I have selected the "Update" selection that appears in the "This workbook contains links to one or more external sources that could be unsafe."
Obviously these sources exist only on my...
I'm updating a macro that is used at my job that was created by someone that is no longer with the company and at the very bottom of the macro there is 2 application run lines:
There are no other macros in workbook and I've...
I have the below code at the end of a macro after switching from workbook (A) to the MMDDYY-SGCS workbook. The entire macro runs in WB(A) then the code below switches to the MMDDYY workbook.
Hi there - just wondered whether someone could help me as my brain is currently fried ..
I have a workbook named KPI_DASH. This collates data collected from various other workbooks i.e BookA. The KPI_DASH workbook is hidden to the user and they wouldn't open it.
Within KPI_DASH is this...
Not really sure how to do this but I have a macro assigned to a button in a worksheet. What I would like to do is AFTER
the macro has been run, lock it until Workbook has been closed and reopened. If the button is clicked prior to closing and reopening
display a message that would...
I have merged several Macros together via the record button. What I want it to do now is to repeat itself at a change of value in column A. For example A1-A10 are the same I would want it to run for those. Then A11 is different, I would want it to insert a row and run again and so forth...
As usual, this is probably a simple answer, but it is stumping me.
I have a couple bits of code that have used for years to ProtectAll, UnProtectAll the sheets for templates. (They are private subs.) That way when I have code to run data imports, etc. I can usually just run the UnprotectAll...
I have a macro in Personal.xlsb called Public Sub Get_Name(shName As String)
When I use below sub to call Get_Name from Personal.xlsb, I get an error at the Application.Run "Personal.xlsb!Get_Name(shName)"
Public Sub Set_Name()
Dim shName As String
shName = ActiveSheet.Name...
I'm a noob in macro's, but i can't figure it out, with forum and record function.
I'm starting to apologise first on my english, because i'm canadian and french :-) loool
I got a totaly fonctional macro, but it's very very very long.
I'm pretty sure you guys expert, can find a way to...
Hello, I am working on a Workbook_Open formula. Right now the formula works, but it's not forcing Sheet 11 & Sheet 12 to do something. Normally on those Sheets once you click V6 (which is a data validation drop down list) it activates a VBA code for Worksheet_Change which tests if V6=V2 on the...
I have been using the Application.Run for a while but something changed and now it won't work!
The only thing I changed is that I added the same command in another section of the procedure and I tried to use a goto to run this code but it skips the Application.Run without an error. Anybody have...
I've written the below code to leverage Solver. I'd like to RoundDown the answer the code churns out but have been having trouble getting it to work. I've been trying to leverage Application.WorksheetFunction.RoundDown, but can't seem to get it to work. Any help would be greatly...
I keep getting this error when running the following code. Please help. Thanks
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B1")) Is Nothing Then
Dim myMSG As String
myString = "***Processing Customer Reports***"
mystring2 = "***Complete***"...
I have a sub that works nearly perfectly, except that excel seems to lag after running. My solution to the lag was always close and reopen excel. I finally added that to the sub (using call at the very end) yet now the original sub does not run in its entirety. I'm at a loss as to...
I'm running subroutines from another subroutine by using Application.run <string> such as Application.run testmacro
The problem is, there is no error if the macro doesn't actually exist. I could just as well add Application.run thisisbogus and it would appear to do something even though it...
I'm quite certain this is a bug and there's probably no fix however I thought it would be worth asking. My issue is that even though I have the "Make Unconstrained Variables Non-Negative" box ticked, it's still using negative variables and crashing the equation!
The solver works by...
I am writing a macro that has to open another workbook (wb2), run a macro in wb2, copy some data and paste it to the first workbook.
However, given it takes some time for Application.Run to actually populate the excel cells in wb2, it seems like the macro i am writing selects the range...
As you know, when passing an argument ByRef the Callee procedure code can change the value underlying the argument in the calling code as shown in the following example :
Dim X As Long
X = 1
MsgBox X ' returns 2