MrExcel Publishing
Your One Stop for Excel Tips & Solutions

UserForm - TakesFocus - LosesFocus


Posted by Jim on December 30, 2001 8:25 AM

Hi group,

With commandbutton_click() i show a userform and
then range("a51").select, does anyone know how to have
the userform "lose" it's focus so i can immediately
enter a value in cell a51 without having to click on
it first. In other words the userform "has focus" and
won't allow you enter a value in the cell until you
click on the cell.

Thanks for any help

Jim


Posted by Jacob on December 30, 2001 2:18 PM

Hi

Userform1.hide will make it lose focus. It will still be loaded, but you can work with the cells.

Jacob