1. Jaafar Tribak

    Reading the ShowModal Property of UserForm at run time ?

    Is there a way to read the ShowModal Property at runtime ? Something like this : Private Sub UserForm_Activate() MsgBox Me.ShowModal End Sub Which obviously generates a compile error Regards.
  2. R

    How to setfocus on modeless form

    Hi, I'm trying to do data validation on a text box on a modeless form (ShowModal = False) the following code works when ShowModal = True, but due to the interaction I need the form to be ShowModal = False. How do I get around this problem??? Private Sub MazeH_BeforeUpdate(ByVal Cancel As...
  3. L

    Switch between Excel windows with Userform open in one

    Hi I have a UserForm (in Excel 2007 created with VBA) which is primarily going to be used to input data into a workbook. The problem is that the data is located in another workbook, and by default, when the UserForm is open in the first workbook, you're not able to switch between Excel windows...

Some videos you may like

This Week's Hot Topics