View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default activate excel application after userform activation in modaless

Hi X Taol,

Try something like:

'=============
Public Sub Tester002()
UserForm1.Show vbModeless
Sheets(3).Activate
Sheets(3).Range("A1").Interior.ColorIndex = 6
End Sub
'<<=============

---
Regards,
Norman



"x taol" wrote in message
...


i opend the userform in modaless.
and then i want to activate not the userform but the xl application.

*** Sent via Developersdex http://www.developersdex.com ***