View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tendresse Tendresse is offline
external usenet poster
 
Posts: 117
Default Activate .. Select .. Initialize

What's the difference between:

Private Sub UserForm_Activate()
and
Private Sub UserForm_Initialize()

Also what's the difference between

Sheets("Sheet1").Select
and
Sheets("Sheet1").Activate

Many thanks, Tendresse