run code from macro

Sub MacroRun() Dim file Dim path As String path = "C:\Users\Desktop\TEST\" file = Dir(path & "*.xlsm") Do While file <> "" Documents.Open Filename:=path & file Call Format ActiveDocument.Save ActiveDocument.Close file = Dir() Loop End Sub This is my code for running a...

Hello everyone i have simple vba code to find a word in the worksheet but i have a small issue, when i find the word the cursor moves to the word but the small window where i type the text disappears , i want to run the program continuously until i press the cancel button and below is my code...

Hi , I have made a user form "Userform 1" where I have a button to Pull up "UserForm 2" which is basically a timer display with a lable box to show time elapsed and a command button to stop the timer. Users are required to STOP the timer when they are back from break. I just need to know how...

Hi all, I have an IF statement where I want code in a different macro executed when a cell is populated with a specific value. My code thus far is below: Sub RUNOPT() Sheets("Main Page").Select If Sheets("Main PAGE").Range("L15") = "A" Then Call RUNA If Sheets("Main PAGE").Range("L15") = "B"...

I have written a code in a Module "ABC" under function "Public Sub CreateRank()" Now I am trying to call "CreateRank()" in my macro but not able to run it. I tried options such as RunCode, openModule but nothing works. Please advice.