Hello, I am very new to VBAs and have figured out how to do these two functions separately but not how to combine them so they will both work on one sheet.
Putting them both on the same Project sheet I get the error message: Ambiguous name detected: Worksheet_Change (See image below)
My primary...
Hi guys,
I'm new to the forum so apologies if I've already broken a rule/some rules by posting this.
I am trying to create an excel for work that doesn't allow the user to save if a cell is blank.
Having copied some VBA coding from the internet, I currently have this in the workbook module...
I am unsure how to combined the 2 macros below so I want get a error. Thanks for the Help
Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)
Dim isect As Object
'Test if target in required range
Set isect = Application.Intersect(Target...
Hi Forums,
I have just completed a long and tiresome VBA code and was excited to send the report out to my boss. However, when testing the file on a coworkers computer, I found that none of my active x controls are working!
On my coworkers computer (have tried with multiple coworkers)...
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.