View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Rooney Peter Rooney is offline
external usenet poster
 
Posts: 325
Default Renamed EditBoxes keep reverting to their old names in UserForm

I have a userForm containing 7 edit boxes, and OK button and a Cancel button.

I wanted to rename two of them, but every time I run the user form, these
two revert to their old names.
I've renamed them repeatedly and even deleted them and recreated them with
the new names I want (but with no success). A text box repeatedly returns to
its old value, too.

As this is my first foray into user forms since Excel 5 (!), can anyone
advise me as to where I might be going wrong? Do I need to save the changes
to the form in some way?

Might I have an old version of the form in memory? Is the a quick way that I
can use to unload any forms that might be in memory before loading the one I
want to work with?

All these questions and more!

Thanks in advance

Pete