1. s_macloskey

    Add +1 to a cell value (plus complications!)

    Good morning all, I have another VBA/AcitveX/Button query that I hope someone can help me to solve! Also please forgive me as I don't 100% know the QUESTION I am asking, I just know the result I am after. (I have also have to redact some of the information becuase of where I work.) Context...

    Insert row below named range while extending that range

    Good evening all, Question... (obviously) Is there a way of making a VBA to insert a single row below the last 'Dep' 'C:C' while extending the range, "B4:J8" has been named "Third_Party", "B9:J10" = "QC", etc... While the formulae in "D8:J8" (also in the named range of Third_Party) would just...
  3. s_macloskey

    Protect/Unprotect worksheet VBA BUTTON?

    Hello all, context: I have created an employee holiday/leave sheet on (we use Excel 365) I have made a sheet for each month and they require 'protecting' and 'unprotecting' seperately/individually - with a password query: My team is not so computer literate so, I need to create an easy to...
  4. R

    Can a Button affect the code of another sheet?

    Hello, I have a very large workbook of sheets that contain macros that causes it to run very slow at times. However, only certain sheets need to be used at a time. I am wondering if I can make a button that when selected hides certain sheets and also comment blocks the code in those sheets so...
  5. M

    VBA Code to click a button on a VBA page

    Hi. I am trying to use my VBA code to click a button on an IE Web page. I have tried various lines of code but keep getting the Object Error 424. Below is the web page code detailing the button.... <td id="cellInvestment </br>Choice" align="left" name="cellInvestment </br>Choice"...
  6. S

    Dynamic Macro Name?

    Hi, I'm not sure this is possible but thought it would be worth asking. I have the following code below, which hides a tab based on a cell. Ideally I'd like a macro button to say "Hide Tab" when it's unhidden and "Unhide Tab" when it's hidden. Thanks for reading, any suggestions welcome...
  7. M

    add data to a certain cell from a listed table value one after another via single button click. it may be in macro or vba code.please help.

    I want to add data to a certain cell from a listed table value one after another via single button click. it may be in macro or vba code.please help in details.

    Include a counter in a VBA macro

    Dear all, I'm using a macro just to suffle a sequence of numbers and then assign that to a button (attached), as follow: Sub Embaralha_seleção() Dim numm() numm = Range("A1:A100") ct = UBound(numm, 2) lt = UBound(numm, 1) ReDim dex(1 To lt * ct) n = 0 For h = 1 To...
  9. R

    Create button that adds rows w/ formatting

    Hello, I have a tab in my workbook that has rows that hide/unhide based off of which radio button is selected. I am wondering if there is a way to use vba to create buttons in a template to make this easy to recreate. If not, do you have any suggestions on how I could go about this smoothly? I...
  10. S

    custom sort button vba

    i need two buttons to sort my data because some days i need my data sorted in way 1 and sometimes in way 2 so i need 2 different buttons for it way 1: its a custom sort on column M and the custom list is ( 24 H, 48 H, 3 days, 4 days, 5 days, 1 week, 2 weeks, 1 Month, 2 Months, Monthly, Yearly)...
  11. M

    Worksheet_Change Add and remove button In Next Cell Based on Cell Value

    I am trying to make it where Anytime you enter the number 100 or more in Range G4:G11 a button assigned the same macro is added to the next cell and fits. When you delete the value in Column G or it is under 100 it deletes the button in column H. Please, Please Help. Thank you, In Advance
  12. K

    Macro-assigned button causes error

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

    VBA macro button to select todays date changes formatting???

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

    Clicking a button on a website

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

    Reset Button for Drop Down Lists

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

    Macro Clear Button

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

    Get value from filtered table vba with button

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

    re-run the macro if command button is clicked

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

    Pls help how to Add multiple rows with same value of combobox through userform

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

    Limit Macro from Filling Past Row

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

Some videos you may like

This Week's Hot Topics