Get instant live expert help on I need help with vba option explicit

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

i would like to an option called null in .xslm file using VBA
Solved by V. U. in 28 mins
I have a Excel Workbook called "PSC Dashboard" I have created a VBA which contains a running digital clock. In order to keep this running I had to protect the workbook/sheet. I also have a VBA under Microsoft Excel Objects then in "ThisWorkbook" that runs the macro as soon as I open the specific file. Option Explicit Private Sub Workbook_Open() startClock End Sub The problem occurs anytime I open another Excel Workbook the running Macro "PSC Dashboard" takes over any other Workbook. I want to keep my PSC Dashboard open yet not have it interfere in my non related workbooks I have open. Thank you, Eugene
Solved by C. J. in 19 mins
How do I run a VBA code copied from the internet to create a multiple selection option from a drop down menu without repetition in VBA editor? The codes I used did not run in the sheet.
Solved by G. U. in 15 mins
Trying to work out a formula with cascading If statements. In cells B10:B13, copy vlaues from A1:E5 with the logic IF VALUE PRESENT IN Option 1, copy value in option 1, otherwise look in Option 2, otherwise Option 3 and Option 4. If no value present in any of the options, copy 0.
Solved by F. C. in 23 mins
VBA CODE HELP. I need help in looping a VBA.
Solved by K. C. in 28 mins