button event

  1. S

    Have MsgBox show other button than Yes No Cancel

    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...
  2. M

    Detect Button Press Event on an Excel Sheet MultiPage Form (NOT a VBA UserForm MultiPage)

    I am struggling to figure out how to detect a button press event on a MultiPage form that resides directly on an Excel sheet. The form is not generated using VBA, it is built directly on the sheet using Developer > Insert > ActiveX Controls > More Controls > Microsoft Forms 2.0 MultiPage...
  3. M

    Macro - Adding Copied Data to BOTTOM of a Table

    Hey Friends, I have a table on 'Sheet1' in my workbook. On 'Sheet 2' I have some formulas happening to determine what needs to be added to the table on 'Sheet 1'. When it's determined what needs to be added to the table, I need that data to be appended to the BOTTOM of the table on 'Sheet1'...
  4. K

    Edit Macro to have button "Unglow" when another button is selected.

    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...
  5. E

    How to Determine Range of A Generic Button Call, Then Delete The Row

    So I have a spreadsheet driven by some data-entry cells and macros, whereby information from the input forms is added to a table... As part of this process, I want to create a standard button (form control) that can later be clicked to delete the associated row (i.e. the table entry)... Here's...
  6. B

    Macros | Multiple data entry and transfer data from sheet to sheet | Mimic database action

    Hi everyone I'd like to ask if it is possible to mimic actions similar to a database but only within the same workbook. If it is possible, I'd like to get a structure code for macros so that I can follow and imitate =) Here's my specs: Here is Sheet 1 <tbody> Column A Column B Column C...
  7. B

    VBA Quick Entry Button-Assigned Macro

    Hi I am creating a spreadsheet that factory operators use to record engineering issues in our factory. There are some that occur on a regula basis and I would like to be able to assign these to individual buttons to save time. Currently the operators can choose the entry values from validation...
  8. K

    Code for a button to add sheet duplicated from existing sheet and auto-name from sequential list?

    Seems complex, but can a single button code; 1) add a new sheet (preferably at the front of the worksheet list), 2) the new sheet will be a duplicate of an existing sheet, 3) the new sheet will be auto-named based on the next sequential cell from a list on a master-data sheet in the same...
  9. M

    My code wont work from button

    i wasnt sure how to explain this the header I have a simple peice of code that clears a few cells. I went back and added another row and therefore updated the code. Now when click the button all my other cells clear as supposed to but my new one doesnt.. but if i run the moduile within the VBA...
  10. M

    Method/code to determine which button was clicked

    I have an Excel 2003 workbook that has many buttons on different worksheets within it and I was wondering if there is a way to tell which button was clicked?
  11. K

    Drill Down Pivot Table Data From Button

    I am looking to add a button to a worksheet which, on clicking, will display the data details from a referenced pivot table. I know that you can display this data when double clicking on the desired total in the pivot table itself, but I have to face reality and deal with many computer...
  12. N

    Can we know which button was pressed on the excel sheet when the buttons are created during run time???

    I have created a button name "Add Power Source" on excel sheet that adds a table and a button(named "Add Row") to the sheet.Whenever the user clicks the "add power source" button a table and a "Add new row " button is created .This "Add new row" button is used to add rows to the table. Now...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top