macro - dailogue box

I am using VBA to do some clean up to a work sheet after users enter some data. Every sheet is going to have only one instance of the following cell combination: <tbody> Some number T </tbody> So I want to find the value in the cell to the left of the one cell with a T in it, produce a...

Hello, I have a Macro that I am using to generate a weekly report which works great. The comments in the macro explains what it is that the macro does. This all works great until it runs up against special characters in the project name (as you know worksheet names cannot have special...

Hello All, I am wanting to perform a simple macro, in my mind, of confirming if a set range of cells all = 0. My current macro is giving me errors. It is the following: Sub ValidateCheckData() Dim ValidationRange As Range Set ValidationRange = Range("H23:I27") If ValidationRange.Value <>...

Hi , I do have a problem on key in a group of vendor invoices in excel to be uploaded to my accounting database where in my excel i do have a table consist of a group of vendor name with a unique code to represent the vendor.For example in excel when i key in a short form name XYZ in columm E2...

Hi guys, I was wondering if it is possible for excel to check when another spreadsheet was last modified. I'm building a macro that gathers information from several different workbooks and condenses it to one report. One of the workbooks has two macro's in there (clearinfo and gatherinfo)...

Hi, I would like to record a macro which when started asks the user to filter the year from a column before going on to complete the instructions in the macro. Is this possible and can anyone help please? Regards Garry

Hi all! I have a question regarding Macros. I have a spreadsheet that I am working on for work and want to insert a button, "Lock" and another, "Unlock" When pressing the Lock button, I want for the entire spreadsheet to be protected. When pressing the Unlock button, I want for a window to...

I am making an expense report for my reps. The national sales manager wants it in excel 2013, and he wants one row that I don't know how to do. He wants the rep to be able to type his mileage into a cell, then have that cell automatically multiply the mileage by $.56 and change to show the...

Hi All, Am kinda new to excel and VBA programming but i have done some assignments on it to understand the flow, am trying to achieve a module which has following requirement : I have a excel workbook which has different Sheets say s1,s2 and s3 it has some data in it, I have a requirement...

Hi all, I've got a macro that runs and every time a new sheet is run a dialogue box comes up saying '.... template is already open. Are you sure to want to open.' and I have to manually click yes for all. How do I make my macro say yes to all and/or ignore the dialogue box? This is my code...