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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top