command button

Hi there, I have tried searching other threads but they were all too old and didn't really answer my problem... I have a command button that when i click it needs to insert a formula into a target cell, i have done this with another button in the same sheet and it works fine but VBA has a...

Hello. I would like delete a button if it exists. I cannot find the syntax that allows for the case where it doesn't exist. I would like something like If “CommandButton1” Exists Then ActiveSheet.Shapes(“CommandButton1”).Delete End If I'm not sure how to write the condition. The Delete part...

I have a simple vba code linked to a command button to clear a range of cells. I would like to add come coding to this to delete a certain shape in the same range of cells. The shape is a: msoAutoShape code: Range("A4:S360").Select...

Hi guys, This probably is a very simple question with a very simple solution but I guess I'm too ignorant about VBA yet. I tried copying the below code into a command button but it comes back with an error. I'd love it if you could explain how to solve this problem since I have many of these...

I have a code built that, upon clicking a command button, displays an email to a coworker when a cell in column P is "X". When a cell in column P is updated a date stamp is automatically entered into the adjacent cell in column Q. How do I update my code so the email displays only if the...

Hi everyone, I apologise for being noob, I'm new to posting on this forum (even though I've been a member for ages!) I'm having difficulty with validation (not my own btw... Excel's) validation works fine when you enter text into a cell, but it doesn't work when you are working with a user...

Hi Guys, I have an excel speradsheet with 22 coulunms and about 1000 rows and growing with lots of macros in it. There is an ADD command button on the main sheet that opens up a VBA scripted table that have drop downs to select data to add to the next row with another ADD DATA button in it. This...

I am trying to cut and paste a row (and keeping the format) to another worksheet and 2 different worksheets in another workbook using a command button for rows in which column K shows a status of "Complete" and automatically save in both locations. In Sheet 1 (Profile Requests in progress) I...

I discovered another thread close to something I am trying to do. Automatically move a row to another sheet based on cell value I am trying to do pretty much the same thing but with a button and with the copied data from columns A-M only going to 3 places at once, another sheet in the same...

Hello everybody, I currently have the following: Where column: I = quantity J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future J = add any number entered from the...

Hello everyone. As the title say, I have multiple (at least 10 I think) cmdbuttons on a userform. I have 2 things I am looking to achieve: 1. Copy the cmdbutton captions to clipboard when clicked. This will be pasted on another program like Notepad, etc. 2. Show the cmdbutton captions on...

i need a command action button to sort a table called table1 based on column ”No. Date” from Z to A. it’s important to note that my table increases everyday so the range must not be limited to a certain limit

Hi, I presently have a number of Private Subs that are triggered by Command Buttons here is an example of two of them 'Security Secret needed If Range("C37") = False And Range("C35") = False And Range("C38") = True And Range("C36") = False Then Range("H13") = Range("AN22")...

I was wondering if it was possible to adjust the text property in a userform command button, such that there is less buffer. I have buttons which measure 24x24. In trying to show text clearly the edge distance buffer should be smaller. Can this be programmed using VBA. I am aware of other...

Hi, I have a spreadsheet which I will require to attach and send PDF files. I need to create some functionality that a command button (or anything functional) will review a value of a particular cell and will attach the corresponding PDF files to an outgoing email. For example, if a customer...

Hi, Can anyone help point me in the right direction to run the code Import_SOR_Data1 by selecting a command button in the ribbon? How to create the command button please? Also not sure if the macro is in correct place in the linked form Regards, Wayne Copy of VOID VALIDATION KCxllinestyle.xlsm

Hi all, I want to reset both my data validation dropdowns and manual entry cells with a single click of the Command Button. I already have the code for the dropdowns from a previous thread, what Macro/VBA should I enter to reset all manual entry cells to blank, and how do I combine the two to a...

Hi all, I have a single worksheet with 20+ data validation dropdowns. I want to insert a Command Button that will reset all the dropdown cells to the first option on the dropdown list when I click it. Having never used Macro/VBA before, I’ve tried researching the appropriate code to make this...

I am trying to create a table on a different sheet that is not my Activesheet using a button. This is my code so far; the problem area is in between the asterisks. Private Sub CommandButton1_Click() Set srtA = Sheets("Competitor Comparison") With srtA .ListObjects(1).Unlist...

Hello, just getting stuck on a little thing here and wondered if anyone could help? I have a command button to email a sheet, it's too much information for everyone on the mailing list so I'm hoping to just pop in a data range into the .body. I'm having problems :( is there a snippet to pop...