Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
Application activation and pasting | Excel Programming | |||
application.volatile activation | Excel Programming | |||
UserForm Activation | Excel Programming | |||
Userform.Activate | Excel Programming |