VBA code autocorrect MsgBox

S.Br.

Board Regular
Joined
Oct 5, 2012
Messages
91
Office Version
  1. 365
  2. 2016
  3. 2013
  4. 2011
  5. 2010
  6. 2007
Dear Mr.Excel;
Until last Monday, Excel VBA v.7 editor always corrected my msgbox spelling making it MsgBox which I've got used to so much that I started looking into my code to see what's wrong with it; all I can see is something I usually do not use: early binding. So, my question is: why does early binding effect the editor? and is there a way to find out which DLL makes the editor unhappy? TIA.
Stay apart, stay healthy!
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
If you type MsgBox (including the caps) does it change to msgbox?
 
Upvote 0
WHOA! Fluff, you just nailed the beast: after I tried your 'remedy' Excel code editor is back to normal. "and I wonder still I wonder" who stole the plane...
Thanks!
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0
and there's one more lil thing...
when printing to pdf, the file name edit box used to offer a drop list with file names matching what's already typed in;
it does not do it anymore, i must've screwed smth up, please advise. tia.
 
Upvote 0
That is a totally different question, so you will need to start a new thread. Thanks.
 
Upvote 0

Forum statistics

Threads
1,214,649
Messages
6,120,732
Members
448,987
Latest member
marion_davis

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
Back
Top