buttons

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Delete

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