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...
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...
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 =...
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...
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...
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...
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...
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...
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...
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"...
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...
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.
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...
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...
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)...
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
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
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.