button

I have a code that generates two new sheets based off of templates every time that it runs. I have a button that the macro is assigned to. When I click the button, it generates the first of the two sheets and then gives me an error 400 message. I go back, delete the sheet that was generated, and...

Hello I hope somebody can shed some light for me. I have a macro button on my s/sheet that runs pretty well to highlight todays date within a row. However it also red borders the left and right side of the column below and im not sure why? It is quite useful and I would like to have the same...

Hi, I'm trying to write a macro to open a website and carry out a search for the location within a Cell in my workbook. The website is the British Geological Survey. Geology of Britain viewer | British Geological Survey (BGS) Typical when I open the website I have to click the button near...

I have a workbook with multiple drop down lists. Unfortunately, all the drop downs are not using data validation. We need to have the list "reset" to the first item of each list. Is there a way to do this with just one Reset Button? Thank you

I have created a clear button on my sheet to reset certain cells to 0 etc. However in some of the cells formulas are also being deleted. Can someone tell me how to correct this problem, leave the formulas intact. Thanks all GT

I create a simple previous-next button using spinbutton to get data from the table, here the code: Private Sub spnPrevNext_SpinDown() Dim wb As Workbook: Set wb = ThisWorkbook Dim shtHelper As Worksheet, shtData As Worksheet Dim lobTable As ListObject Dim FindData as Range...

Dear Learned people I have a macro that, when it has run through all the code saves the workbook with a different name using "Save As" . I added a command button "Save & New" on a user-form in a certain position in the code. I would like for the user to save the workbook (Save As) and then...

I have created a userform Which have a combobox and a text box, save button. Now when i select a value say"ABCD" in combo box, i will mention say number as "5". Now when i click on save button, then 5 rows of value "ABCD" should be created in excel cells in the column i specify. And next time i...

Hi, I am making a Name List where people can put their name in a cell, and click on a macro-recorded button to automatically add their name to a new row in an existing list. However, I am trying to add VBA to set a limit to the number of rows that can be filled in this list. So, if I want the...

Greetings, Hoping someone can help with a script to make a Button (form control) copy the value from cell D4 and write it into the cell which is referenced as an absolute in cell E4. I'm not sure if I'm using the right button btw. Any help appreciated :-)

i have a control button named "button 61" and a macro is assigned to it, within that macro there is a code : Worksheets("4_Lift Plan").OptionButtons("Button 61").Visible = False which esentially tells to make this same button invisible if certain condition is met and when i run it there is error...

many sources mention that when i add a control button from form controls into worksheet and right click on it, there should be option for properties from which i could change font, color , name etc.. but unfortunately when i do right click only options i see are: cut, copy, edit text, grouping...

I've created a link with the HYPERLINK formula which is using customer IDs from another cell inside the Hyperlink. Works like a charm. Now I've been trying to make the Excel a bit nicer looking. Is there any way to replace the links with a button or a button-like graphic so it doesn't just look...

Hi: I have the following code which I am trying to use to clear out the data fields in a pivot table and substitute with a data field selected by the user with a macro button. The code falls down on the very last line showing a 'Run time error 5 Invalid call or argument'. Please help! Sub...

On: Sheets("Players") I have a command button, when clicked this runs: Private Sub CommandButton1_Click() Dim Player1 As Variant Player1 = InputBox("Enter Player 1") ActiveSheet.OLEObjects(1).Object.Caption = Player1 ActiveSheet.OLEObjects(1).Object.BackColor = 49152 End Sub On...

Hi all, Apologies for the simple request as a beginner to the forum, but I would like to have a button on a spreadsheet that I can delete either a specific column or row. I have code to remove a column as follows: Sub DeleteColumns() Dim varUserInput As Variant varUserInput = InputBox("Enter...

I need some help here as still learning Excel Macros I have few sets of code within an excel file. 1) clear "results" data if "input" criteria has any change 2) Export "results" as a separated file in values only - button 3) Import "Database"- button So far, I tested them separately, all are...

Hi, I am very much a beginner with excel, but wanting to add a button on my spreadsheet to add a column after a specific column. The code I have put together is as follows: Sub AddColumns() Dim varUserInput As Variant varUserInput = InputBox("Enter Column Letter where you want to add a...

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

i'm looking for a vba code where i can click the command button to add the exact date and time Now() smthn like this ? any idea ?