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 ***

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 ***

THE problem is the activate.
currently, the activation window is the userform.
but, i want to activate the xl window.

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

Hi X Taol,

The suggested code was intended to demonstrate the activation of the Excel
window.

What are you unable to do with the form displayed modelessly?

---
Regards,
Norman



"x taol" wrote in message
...


THE problem is the activate.
currently, the activation window is the userform.
but, i want to activate the xl window.

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

AppActivate Application

AppActivate UserForm1.Caption

Regards,
Peter T

"x taol" wrote in message
...


THE problem is the activate.
currently, the activation window is the userform.
but, i want to activate the xl window.

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

Somehow I failed to see Michel had already answered

Peter T

"Peter T" <peter_t@discussions wrote in message
...
AppActivate Application

AppActivate UserForm1.Caption

Regards,
Peter T

"x taol" wrote in message
...


THE problem is the activate.
currently, the activation window is the userform.
but, i want to activate the xl window.

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

Hi x taol;

Private Sub UserForm_Activate()
AppActivate Application.Caption
End Sub

MP

"x taol" a écrit dans le message de news:
...


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 ***