1. E

    Large Spreadsheet Help!

    Hi All - I'm looking to develop a spreadsheet which can collate all of the contacts that we receive as a team. We have developed a template page for each company/ organisation that contacts us. I'm looking to create a summary page which provides a line with each company/ organisation number and...
  2. Jaafar Tribak

    ScreenTips For Shapes and Buttons.

    Hi dear forum, I just thought I would post this code here which should accomplish what the tread title suggests. It is similar to the code I posted here for worksheet tabs screentips. As we know, shapes and buttons placed on worksheets don't have screentips ( Including ActiveX controls ) and I...
  3. T

    Macro to open hidden tab - using shape as button

    I'm looking to make a super simple macro that just pulls the text out of a shape and uses that to unhide and open a tab on click. Sub ButtonToHiddenSheet() Dim ShtName As String ShtName = SHAPE TEXT Sheets(ShtName).Visible = xlSheetVisible Sheets(ShtName).Select End Sub I...
  4. H

    Macros stopped working from buttons

    Hi, this is such a strange one I had to post a thread (not something I've done before, so forgive me if I make any errors). All our users are on Office365 (installed locally, not the web version). Most users are on Win 10. My boss has a macro-enabled template that is used by multiple staff...
  5. J

    Making changes to worksheet buttons in Excel clears the undo stack

    I have some buttons an Excel sheet and and I have VBA code that changes a property of a button based on user actions. The problem is, once VBA changes the button property, it considers it a worksheet change and clears the Undo stack. I know there's no way to prevent VBA from clearing the Undo...
  6. O

    Adding and Assigning Photos

    I have an asset list of 200+ items. I would like to add photos of each asset to its row. So far I have this command button vba Private Sub AddPicture_Click() Dim strFileName As String Dim objPic As Picture Dim rngDest As Range strFileName = Application.GetOpenFilename( _...
  7. T

    Insert a new row, keeping data validation - Macro/Button

    Hi all! I am looking to add a button to a spreadsheet which will insert a new row at the top of the table (row 2), whilst keeping the data validation & formatting of the row below. You will see in the example excel doc which I've attached that I have created an array alongside the table. This...
  8. M

    Macro to increment cells using buttons

    Hello everyone I'm trying to solve a basic problem using form controls (Buttons) and macros but don't have a very good idea about how to exactly go on about it. Could you please help me out? Problem Description: A B and C are 3 buttons which increment the value of A, B or C by 1...
  9. S

    Macro Assistance with a Drop Down Listy

    Hello - I would like to develop a "Jump to" macro button that jumps to the appropriate section of the worksheet to display the data. The corresponding data are listed in column A of the worksheet in different cells (ranging from cell A6 to cell A347). I have tried code from other forums but...
  10. K

    run time error'9':subscription out of range

    i wanted to disable radio buttons through vba code using this code: Worksheets("Sheet4").OptionButtons("Option Button 18").Enabled = False but when try to run it says "run time error'9' :subscription out of range". How can i make it work. those radio buttons are in normal worksheet not in...
  11. G

    Screen Refresh

    On one worksheet I have a group of buttons (not actually grouped, but just adjacent). When I click one of the buttons is unhides another worksheet and hides the first worksheet. The buttons show as an image on the second worksheet and the real buttons on the second worksheet are not visible...
  12. S

    A convenient way to batch rename ( not caption ) multiple command buttons on Userform ?

    Hi, I am creating an Userform with several command buttons on it. Is there a way to batch rename them as : cbButton1 cbButton2 cbButton3 cbButton4 cbButton5 … ? Note: I hope to give new names to them. not to change their captions. The way I am using now, is simply click on them 1-by-1, and...
  13. gheyman

    Using Toggle/Option Buttons

    I put two option buttons on a form and I am trying to figure out how to use them. Where is the Value stored when one of the Options are selected? I want to use these buttons in an If statement. Option246 Option248 I tired to test it: Private Sub Frame244_Click() If Option246.Value = "1" Then...
  14. K

    Buttons on works Books

    Good Afternoon, I am trying to make some changes to an old work book. It has some buttons that are slightly different to anything I have come across before. I am used to buttons that have a macro assigned to them, however these buttons are all triggered by cmd_Click events on the work sheets...
  15. TAPS_MikeDion

    Can you change a button group lock options to True/False with 1 command?

    Just wondering if I can shorten my code a tad by changing grouped buttons with 1 command instead of two. For example: If you have a group of two radio buttons (for this example I'll call the group "NewEmp") and you want to lock or unlock them, do you have to use two commands (i.e...
  16. C

    VBA saving tab in new workbook but button linked to old

    I have a report that allows users to make individual files for their reps. However there are a couple of macro assigned buttons on the tabs that are used to make new files. The code teavels with the transfer because I have it in the sheet area and not in a module. However the button...
  17. A

    Looking to make custom Ribbon buttons

    Any really for idiots guide to making custom Ribbon buttons? I'd like one that toggles between "Center Across Selection" on and off. Another that toggles through Plain, Underline, Single Accounting Underline to ideally replace the underline button. Is this possible? I downloaded the...
  18. I

    Custom MsgBox. Buttons

    Evening, I’m looking for a msgbox but with buttons as 1 & 2. Is there a way to do this without it being a userform. Thanks
  19. Knockoutpie

    How do I assign different subs to user buttons?

  20. W

    VBA Running Slow

    Hi All, **Newbie VBA/Macro user*** - I use forums and Youtube to learn how to code but in there somewhere are probably some bad habits. I have a form button on a project i'm working on which has now gone a bit slow to calculate. The button picks a random number between 1 and 10 in the...

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