I want to add code to some columns in a sheet to define the number format or date format using the following codes
ThisWorkbook.Sheets("Report").Range("E2:E" & Cells(Rows.Count, 1).End(xlUp).row).NumberFormat = "mm-dd-yyyy" ' date format
ThisWorkbook.Sheets("Report").Range("J2:J" &...
Hi,
I am need my macro SORT_SAP1 to launch if cell "P12" changes. Can some one help me with the correct syntax for the worksheet change event?
Thank you!
Hi!
I haven't been able to find an answer on this and my issue could be piecing together code I found on multiple forums. This worked fine with the first combo box I tried but I am unable to get this to work on subsequent worksheets. My goal is to have an ActiveX ComboBox drop down...
Hello,
Any ideas as to why this will not run. I've been playing with it all day and can't figure out why it stops after the If statement is evaluated.
I'd bet money it's something minute I'm overlooking but I can't find it. I have changed everything I can think of in the two statements...
I have a multi-sheet workbook. The first sheet is a summary of results from the rest of the workbook. I would like this summary sheet to auto-refresh itself each time the sheet is activated. The VBA code triggered by the Worksheet/Activate event feeds some parameters out to other sheets, then...
Hi guys, is it possible to call a Worksheet's activate event from a procedure? Or maybe, refresh a worksheet from a procedure. i'm using excel 2003.
Thanks
Shie Boon
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.