| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button on Userform calling GetOpenFilename
Hello,
Situation: Userform with Button, Button_Click Procedure contains "Application.GetOpenFilename". When I have done my file selection the GetOpenFilename dialog will be closed and I see the calling Userform. Now the Userform seems to be not modal, I can select cells, sheets, but I can't enter values in the cells. Question: How can I avoid this behaviour, I'd like to have a modal userform as it is declared. Thanks Best Regards Werner |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button on Userform calling GetOpenFilename
Hi Werner
Weird. I never noticed. Seems to behave ok if you hide - show the userform though: Private Sub CommandButton1_Click() Me.Hide TextBox1.Text = Application.GetOpenFilename Me.Show End Sub HTH. Best wishes Harald "Werner Rohrmoser" skrev i melding m... Hello, Situation: Userform with Button, Button_Click Procedure contains "Application.GetOpenFilename". When I have done my file selection the GetOpenFilename dialog will be closed and I see the calling Userform. Now the Userform seems to be not modal, I can select cells, sheets, but I can't enter values in the cells. Question: How can I avoid this behaviour, I'd like to have a modal userform as it is declared. Thanks Best Regards Werner |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button on Userform calling GetOpenFilename
Harald,
thanks, I've tested it and it works. Regards Werner "Harald Staff" wrote in message ... Hi Werner Weird. I never noticed. Seems to behave ok if you hide - show the userform though: Private Sub CommandButton1_Click() Me.Hide TextBox1.Text = Application.GetOpenFilename Me.Show End Sub HTH. Best wishes Harald "Werner Rohrmoser" skrev i melding m... Hello, Situation: Userform with Button, Button_Click Procedure contains "Application.GetOpenFilename". When I have done my file selection the GetOpenFilename dialog will be closed and I see the calling Userform. Now the Userform seems to be not modal, I can select cells, sheets, but I can't enter values in the cells. Question: How can I avoid this behaviour, I'd like to have a modal userform as it is declared. Thanks Best Regards Werner |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get userform Cancel button to invoke Exit Sub in calling macro? | New Users to Excel | |||
| Calling a Userform from a Predefined Variable | Excel Worksheet Functions | |||
| Calling function from a userform | Excel Discussion (Misc queries) | |||
| VBA question - Calling txt file from userform | Excel Programming | |||
| VBA question - calling Procedure from userform | Excel Programming | |||
Hybrid Mode
