1. J

    Hide/ Unhide Rows based on Text Value - Checkbox

    Hi All, Can someone please help me to hide/ unhide rows on another sheet based on Text Value? For example, if 'Purchase Order' is enabled using a checkbox or a button, then rows containing 'Purchase Order' in a specific column, in this case Column D, will be shown. Note: I am trying to make...
  2. K

    User Form Button disappeared from Home menu.

    I had a programmer crank out some vba for me that essentially allowed the user to go to the Home menu, click a custom button called "Import Folder Files". Once they clicked this icon, a form would popup and ask them to identify the folder that contained the files you wanted imported. User then...
  3. A

    My delete picture code doesn't work

    Hi everyone, I used some codes to insert a picture in a sheet. Then later I want to delete it, but leave the command button. I tried 3 different codes but none of them works. This one doesn't do anything Dim Pic As Shape For Each Pic In ActiveSheet.Shapes If Pic.Type =...
  4. D

    Export to PDF macro fails on Excel Office 365, not on Pro Plus 2019

    Hi, I have a button inside Excel workbook which exports certain pages to PDF with one click on a button. The Excel version I am using is Professional Pro Plus 2019 and my customers version is the same build, but an Office 365 version. If I hit the button in my version it works, but if my...
  5. L

    Macro to create new button

    Does anyone have any experience with a macro the creates a new button, the new button created then has code created for it based on a template so that when it is run it will do as specified. It creating a list that has a button on each row where you can delete that line or tick done. I also...
  6. 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...
  7. D

    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...
  8. 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...
  9. 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...
  10. 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"...
  11. 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...
  12. 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...
  14. 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...
  15. 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)...
  16. 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
  17. 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...
  18. 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...
  19. 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...
  20. 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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back