Range Select Active Cell has Focus?

[James]

In my code after a UserForm is displayed i
have,Range("B10").Select, it selects it
but you still have to mouse over and click
on it before you can enter a number. Does
anyone know how to make the selected cell
active?

James

 

[RWinfield]

On 2002-04-21 10:51, James wrote:
In my code after a UserForm is displayed i
have,Range("B10").Select, it selects it
but you still have to mouse over and click
on it before you can enter a number. Does
anyone know how to make the selected cell
active?

James

James, try Range("B10").Activate instead of Select.

 

[James]

Thanks RW,
I've tried that and eveything else i can think to try. It has something to do with the
UserForm "having the focus" that overides
select and activate

James

 

[James]

I found this in my files credit: Ivan F. Moala

AppActivate"Microsoft excel"

James