I have created a form in the Visual Basic Editor, using the toolbox. When I view Code, it is empty. How can I see the code that was used to create the userform so I can use more complex formulas in the text boxes?
thanks. Joel
I have created a form in the Visual Basic Editor, using the toolbox. When I view Code, it is empty. How can I see the code that was used to create the userform so I can use more complex formulas in the text boxes?
thanks. Joel
Hi Joel!
it is empty?? Select Userform1(or 2 or 3) from "Project Window" of VBE, and right click then select "View Code".
I think it's one of correct ways.:)
Hi Colo,
thanks for your reply. I can open the Code window fine. I worked out it is empty because it does not show the code to create the form as I expected. Rather, here I can enter the code I want to control the data in the form.
Regards, Joel
Joel:
I'm confused by your statements. To my knowledge there IS no code used to create the form--you created it, yes?
If you are talking about wanting to see the code that brings the form into focus, then you should be looking at the code of whatever command button or action is taken to bring the form up...
Yes, dreamboat, that's exactly right. I worked it out now, thanks!
Don’t have an account yet? Register yourself now and be a part of our community!