VBA function having it's name's case changed in excel

Hot Topic

How to control one Excel.Application from the other?
Setting back color in MSComctlLib.TreeCtrl.2 control using VB for MS Access
MS Access pivot table problem, field list not available & can't drill down
How Can I Register The Yahoo DomainKey For My Mail Server ?
Programming Adobe Acrobat Reader 7.0
Summing up hours on form based on parameter query
What is the code for closing out an excel file while in the browser?
I need a looping vbcode to use in excell
Argument syntax problem
Using VBA to send an MSN instant message

Microsoft ISV

Using VBA through word, lost all menus (file, edit, etc.)
Install BSM Server error!
Creating and Editing Microsoft Access Reports using Visual Basic
Setting Password reminder questions.
Once copied, can we export as a GIF file?
Object Browser
faxing through execl
error in formula
Count characters in a string using VBA in excel
Creating Logon in MS Access

VBA function having it's name's case changed in excel

I am just starting with VBA / excel though I am a moderately competent programmer. I created a function B4FirstBlank() (written exactly like that) that looks at a Range reference and finds the value of the cell before the first blank cell. It works fine but whenever I type it into excel it is rewritten as

b4fIRSTbLANK()

which doesn't do much for me in terms of readability. I get other strange rewriting of functions too, any guidance on how to sort this out much appreciated.

Andrew

Answer this question

VBA function having it's name's case changed in excel

  • bhavu

    Thanks for the reply. I've had a good look and it is definitely called B4FirstBlank(). For some reason it is now appearing as b4firstblank(). I have also looked for multiple definitions and while I do have the same function amongst my utility functions it has the same name and case and it is easy to test that it is not being used (ie the version in the workbook module is being used).

    This isn't a big deal but it is definitely annoying.

    Andrew

  • Crazy Engineer Kid

    Typically, the IDE uses the declaration/definition of the function to determine its case throughout the module. Check the definition of your function to make sure that it's formatted correctly -- if not, and you fix it there, the fix should be propagated throughout your code automatically.



  • VBA function having it's name's case changed in excel
Answer this question