button macro

Hi, Not sure if it is possible to add macro buttons with VBA, but here goes my question: This is my sample table: What I'm trying to do is have a VBA that will create a button on each cell on column K, that when clicked, it will open a windows folder based on the date on column C For example...

Hi I am new at macros and VBA editing. I wanted to split txt form numbers in cells so I putted this code in module: Public Function SplitText(pWorkRng As Range, pIsNumber As Boolean) As String 'Updateby20150306 Dim xLen As Long Dim xStr As String xLen =...

So currently my code has vbQuestion & vbYesNoCancel. I am trying to figure out if I can replace Yes No Cancel with my own options. Preferably (not necessarily) without editing code too much. If Dir(FPath & "\" & FName & FExt) <> "" Then wAns = MsgBox("The file already exists. Do You...

Good morning, I am using a button to move end of day balances to beginning of day and clear out data. If the button is clicked twice it will move 0's to the beginning balances. I am trying to prevent this from happening. I want the button to only be clicked once until the file has been saved...

Good afternoon, I created the following macro to move a few numbers and then clear data from cells. The macro works perfect. I was hoping to add a clear button for some to just push when they needed to clear the spreadsheet. When assigning the macro to the button (on sheet "Blotter") it tries...

So I have a report that is emailed to me daily, I have a macro enabled to save the files automatically to a location on my desktop (C:\Users\rwebber\Desktop\TSA Hourly Report) and the file saves as SSC Hourly Update "the date it was emailed". I would like to place a button on my page called...

Hello all; I'm still learning advanced excel functions, so I really appreciate any help provided! I hope my terminology is correct too: If I have a value in cell A1, can I use that value as a variable to target an file for opening? Say I have a .doc saved in a job number file numbered 1001...

I'm looking for a bit of help for a pretty straightforward small project. I'm fairly familiar with all the basic functions of excel, VLOOKUP, pivot tables, etc., but clueless when it comes to VBA. I realize it can probably be done manually pretty easily, or using helper columns or similar, but I...

I have a button (Form Control not ActiveX Control) that when pressed, calls a sub procedure inside inside a worksheet module for the worksheet that the button is on. For whatever reason after opening the workbook the first time I click on the button, it produces a 400 error: Every time I click...

Hello all, I'm trying to run all my worksheets from the Sheet1 (Report) with using just a button. Currently I have to go to each sheet and run them one by one. I'd like to have this automated. here is my code that I have in all 72 worksheets (I have this type of format "But different Ranges"...

Hi all, I honestly have no idea where to begin with this so was hoping someone could help me out. What I am trying to achieve is have two buttons, 1 of which (New Item) will make a copy of the section in my sheet from A11:I20 and insert it below with the item number etc blank ready for a new...

Hi guys, I have a worksheet with a long list of worksheet change events. I am trying to create a toggle, preferably a button on the worksheet, that will deactivate all the change event code when clicked, but then activate the same code if clicked again and so on... The purpose is so users of...

I am looking to create a macro button. I have no experience with macros, etc. I have a cell (N3) in Sheet 1 (called "16-17M"). I need this value to match a cell (B3) in Sheet 2 (called "Goal Tracking"). I have some conditional formatting that tells me when cell N3 does not match B3. I would...

Hi Everyone, I am copying a module from one workbook to another so that in the future, the new workbook can run a macro from within itself rather than referring to an external workbook (which may or may not be open in the future). Then I create a new workbook by moving a sheet from one to the...

I have two workbooks, Workbook A and Workbook B. Workbook A has data that I need to input into a specific worksheet (let's call it "Data") in Workbook B. The data I need from Workbook A is in A18:AM18. I need it copied into Workbook B in the "Data" worksheet. However I need to do this each...

Hello there, I am using Excel 2010 Issue: On clicking the 'export' button embedded on worksheet gives the undesired result. So need to edit the code. Result: After clicking the button a dialogue box shows up with text 'Export Complete. Export files have been saved in XXXXXXXXXXXXX' Desired...

Hi, I need a macro button that I can click to add information from a cell in a different Workbook, based on 2 common numbers (called D No.and Z No. ). The info in the cell that I want to copy has been concatenated. The concatenated info is in the form of 5 digit numbers each separated by a...

I have the following Macro which adds a glow to a shape when clicked. Sub IsoscelesTriangle2_Click() ' ' IsoscelesTriangle2_Click Macro Dim Shp As Shape Set Shp = ActiveSheet.Shapes(Application.Caller) With Shp.Glow .Color = RGB(0, 255, 0) .Radius = IIf(.Radius...

Hi guys I have assigned a Macro to a Button. I run a Macro to copy all worksheets to a new book before i start working on it. The Macro that i run also closes the Origianal book and only leaves the copy open. Now, there is a Macro Button in the original document. The button copies correctly to...

How do I extract the data of a cell located in an existing .xls file into a designated cell in a different .xls file. Example: Extract data from cell A2 of "thatfile.xls" to C5 of "thisfile.xls". Could this be coded to be done with a button located in "thisfile.xls"?