I have created a macro in excel for those of you who dont already know. I have a user form that runs on the screen. The problem iam facing is when i try to load the macro on different types of computer screens the userform does not remain the same size. Is there a way to correct form resolution in vba?. Or am i just dreaming?. If no, is there a way to get around it?. For example have my userform expand to the edjes of my excel sheet for example. Any suggestions would be helpful. Note: I dont want to change the user's screen resolution. But i'd like to resize my userform according to their screen resolution. Iam writing my macro in 1024x768 resolution. Also, when i resize my userform i'd like it to be almost or close to the legibility as my original screen.