Wed 8 Jul 2009, 14:30Delegate Oliver said...
Oliver has attended:
Excel VBA Intro Intermediate course
Letter references
What was the short code needed to prevent need for ASCII accuracy when entering code - eg so you could enter any case letters into a combo box on a form?
Thu 9 Jul 2009, 10:07Trainer Anthony said...
RE: Letter references
Hi Oliver, thanks for your query. Option Explicit forces you to be specific in how you declare your variables and that can be toggled on (to force case sensitive use of variables) or off (to allow case insensitivity...and therefore typos!). It needs to go at the start of your code if your going to use it. Case sensitivity in combo boxes and on forms is a separate issue to the code and you need to alter the properties of each individual control to ensure case sensitivity.
Hope this helps,
Anthony
