userforms vba

Hi, I am trying to improve the form open events to be placed in the middle of the active screen, but I noticed I have to repeated it thru all Initialize event of each form. This is the code I am using to call a function to calculate the window sizing: Private Sub UserForm_Initialize() Dim...

I have a termination issue. This is a spreadsheet the grow to a have UserForms for the front end, tons of VBA and about 50 spreadsheets. I'm not an OO guy so I'm sure the way it was done would make an experience coder cry. However for the most part it works. By my standards this is a huge...

Hello again everyone! I'm getting this error the second time I click the button, to which this code is assigned. I suspect I'm not referring properly to the word or excel objects, but I'm not sure where I'm going wrong. Could I please convince someone to look through this rather large piece of...

Hello, I have a problem with a simple macro that launches a user form before saving that is running very slowly for some users. 'Code to reset the workbook view back to a default setting Application.ScreenUpdating = False Sheets("Regulatory CEs").Select...

So I have created a macro to import data from another file when a document is opened. In an attempt to occupy the user I have created a user form to display while this runs and hidden the Excel file itself whilst this is the case. The only problem I now have, is that when the source file is...

Hi there, I've tried searching of ways to do this but have not found a way. I'm fairly new to VBA too, so please be patient if this has already something you've broken your heads over :) Your help would be much appreciated! The problem: I have data for over 100 headers, so when it comes to...

Hi, I have a userform which updates specific data in my sheets. I have a code that updates the data but will only update one of the sheets(Usually the closed to the master). Also the code is written to not update the "Master" I'll post the code. Ant help would be greatly appreciated...