activate excel application after userform activation in modaless
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 *** |
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 *** |
activate excel application after userform activation in modaless
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 *** |
activate excel application after userform activation in modaless
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 *** |
activate excel application after userform activation in modaless
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 *** |
activate excel application after userform activation in modaless
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 *** |
activate excel application after userform activation in modaless
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 *** |
All times are GMT +1. The time now is 04:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com