buttons

I have a series of 8 option buttons and 1 text box in a frame. Whichever button or text box is selected. Enter yes or result (text box) and the remaining will show N/A (They all have their own cell in a row on the worksheet. When I run the code now. I get True or False for the option buttons...

Hello all! I have series of add-ins that insert their own buttons into my custom tab on the Excel 2016 ribbon. The code runs from Private Sub Workbook_AddinInstall() in ThisWorkbook of each add-in. No problems there. I've created an add-in manager form where users can select what add-ins they...

Hi I am struggling with getting a macro to run when I create a new button on a sheet. I assign the On Action to the button and the macro runs without debug, but... the OnAction doesn't run the Macro "Test". The Button being copied to Sheet2 is on Sheet1, then the Macro should automatically run...

Hi How can I use VBA to find and list on a new sheet where external links exist in: Buttons (ones used to run macros when clicked) Charts Pictures Conditional Formatting Data Validation (e.g. lists) Shapes Pivot Tables Named Ranges Cells (likely to be the "easier" ones to find) Thanks

Hi All, I have a situation here and need help. End goal: Hyperlink or button with Concat emails that can be copy pasted in outlook "to" field Prob: Column A = Name of members Column B = Email IDs of members Column C = Title: Use case 1 --> People who should receive email for use case 1 have...

HI, ive made a one sheet document that i want to publish on google docs and use as a basic calculator when im on the move. trouble is when i open it in google docs all the spinner buttons do not appear..

I am working on protecting my workbook but I have many backend macros and macros tied to buttons. Research found that the recommended way to protect worksheets and still allow macros to work is to use the userinterfaceonly = True property. i have been testing each of my worksheets to make sure...

I currently have workers filling in paper check sheets for their vehicles which i can only get hold of at the end of each week, this puts me behind and has poor visibility on paperwork completion. I am trying to put together a data sheet each person could fill in. This needs a drop down menu...

Good afternoon! I am trying to set up a Workbook so that using Save or Save As is disabled but Macro buttons that do specific Save As commands are allowed. I have the following code which works well at disabling Save and Save As, but it won't allow macros that are tied to buttons to perform a...

hello, I have an excel book i created to track inventory. The book has a sheet with a list of users (A), their initials (B) and a password(C). I have placed multiple command buttons on certain sheets that each run a different macro. What i would like is a way for users to be able to log in and...

Hi I am designing a calendar with 365 command button as 365 days, and all buttons has same codes in spite of indexes. Is there any way to have one procedure instead of 365. for example my first day on seventh month procedure is here: Private Sub day_7_1_Click() For i = 1 To Sheets.Count If...

Hi, Could someone tell me why the 1st code works but the 2nd doesn't? Both should print out "2" as the result yet only the first one does. Thanks for looking Sub get_commonShips() Dim IE As New SHDocVw.InternetExplorer Dim HTMLDoc As MSHTML.HTMLDocument IE.Visible = True...

I created and administer a Microsoft Access Application -- there are about a dozen users. I created an accde file that i distributed to all the users to put on their respective desktops. Every time I make an update, the application identifies that there is a new version available, and a batch...

Hi there, I have this number format - _-* £#,##0_-;[Red]* £(#,##0)_-;_-* "-"??_-;_-@_- however I cant align left, centre or align right from the buttons on the ribbon. Is there a way that the above format could be altered to allow me to use the alignment buttons Also is there a way...

Hey guys, need a little help here. I'm working on a proposal sheet for a business and I want to add a button on the top that would let them reset the quantities all to 0. I have a "Description" column that has values such as header, product, description, and subtotal. Basically what I need is...

Hi, Is it possible to terminate a pop-up message box, by using something like Ctrl + Break, without clicking on "Yes", "No", "Cancel" etc... buttons ? I have a command button on an userform. When it is clicked, a message box would pop-up. However, pressing Esc / Ctrl + Break seem not working to...

I've got a big ole excel file with 504 sheets, 500 of which are identical with tab names of 1 through 500 and have two buttons on each sheet. Unfortunately, those buttons were supposed to have macros attached to them but it didn't work. Can anyone help me attach macros to the two buttons...

Good morning! I am wondering if there is an easy way to make 6 macro control buttons all the same size. I have the drawing toolbar enabled and have used the Align and Snap options but would like to find a way to make them a uniform size if at all possible for aesthetic reasons. I appreciate any...

Good Morning, I wrote this piece of code to attempt to close excel if the userform "X" is used to close the userform. Basically the userform opens when excel does and asks for one of two buttons. If neither button is pushed (i.e. someone closes the userform), then I want excel to close...

Hi, I am facing some trouble formulating a macro to run upon closure of workbook. I would like to run a macro to check if there are unselected option buttons within my specific sheet. The option buttons grouped in rows of 5 where only 1 can be selected per row and it runs down as long as the...