PS - I'm still well impressed with those forms. Declare the variables and avoid using ‘Variant’ Data Type. We can fasten the execution of macros or VBA Procedures by following the below tips. This helps interviewer to understand your real time experience in VBA. You can develop educational apps, financial apps, games, multimedia apps, animations, database applications and more. In VB 6, there is no limit of what applications you could create, the sky is the limit. No wonder you were having so many horrible problems.Īnyway, all code that is not needed is now commented out ( quite a lot in comparison to your original post - COORX and COORY are no longer used). This is also one of the most frequently asked Excel VBA Interview Questions and Answers. Visual Basic Sample Codes Visual Basic 6 is a third-generation event-driven programming language first released by Microsoft in 1991. For what you need this should be zero ("0-manual"). This basically means the forms have a life of their own. Looking at it closer you had the "STARTUPPOSITION" property on each of the user forms to "1-Centre Owner". The problem was when I fixed it as I thought it should work, it didnt work at all. Sounds kinda dumb and obvious, but It didnt occur to me before now. set the co-ordinates of the new form BEFORE it is displayed. show method and then you were chaning its cooridnates, which - while it moved fast, looked like a flicker on the screen (clearly not fast enough ).Īnyway the solution was simlpe. The problem as I say was because you were displaying the form with the. You are running into one of the limitations of Implements in VBA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |