VBA dot required to use function

Bowermml

New Member
Joined
Mar 7, 2016
Messages
5
I have a users machine that won't run the Excel vba functions, such as left or environ (or maybe all vba functions) without explicitly prefacing it with VBA. (vba dot).

Just this machine right now. I have never seen this before. I don't want to have to go back through the code and preface every function with vba dot.

Does anyone know why this would occur?
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,218
Office Version
  1. 365
Platform
  1. Windows
Have a look under Tools>References... on the user's machine and see if anything checked that is also marked as MISSING.

If there is anything note it's name, uncheck it, save and close the file, reopen it and try the code again.
 

Bowermml

New Member
Joined
Mar 7, 2016
Messages
5

ADVERTISEMENT

I think that might be it. There was a reference to a missing ocx that I thought I resolved in my install script, but now I am thinking I didn't. I will let you know when I have access to the user's machine in the morning.
 

Bowermml

New Member
Joined
Mar 7, 2016
Messages
5
Sorry for the delayed update. The problem was a broken reference. It was an old 32 bit .dll that had to be removed from Excel to make it compatible for 32 and 64 bit Office. Even though I removed the reference and it worked on my test machine, the reference was somehow staying alive. When the file got passed around to other machines, it was causing the issue. I can't remember exactly what I did, but it was something along the lines of adding and removing the 32 bit reference multiple times before it went away. Once the reference went away, so did the problem.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,694
Messages
5,597,571
Members
414,156
Latest member
WDMix

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
Top