View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff[_4_] Harald Staff[_4_] is offline
external usenet poster
 
Posts: 70
Default hide a textbox on a userform?

Hi

Father-to-son speech coming up <g:
Always use "require variable declaration" (Tools Options menu in the VBE). This will put
"Option Explicit" on all code modules and force you to declare everything. More work,
better habits and far more efficient code that use less memory and time to run.

One nice effect of this setting is that misspellings will produce errors, the debugger
will spot them and take you right there with some information on what's wrong.

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.

"robinD" wrote in message
...


That did the trick -- Bad spelling will get you every
time. Good thing I'm not a doctor!

Thanks!