PDA

View Full Version : [SOLVED:] VBA Word UserForm - Adding a Minimize Button Function



dj44
02-07-2016, 02:56 PM
Hello all, :grinhalo:

right I have this userform in word , I am trying to minimise it but theres no button.



15364

I have read the good work of Mr Chip Pearson here.


cpearson.com/excel/formcontrol.aspx

but it wont let me post the link -arghh

I dont know how to use the function in my word userform - i tried adding it under the code below




Sub Document_Open()

'Show Userform on Opening Word Document
Application.WindowState = wdWindowStateMinimize

UserForm1.Show vbModeless


End Sub






Most of the solutions are for excel userforms and I wasted a day - fiddling about to no success :banghead:


I need the button option as the form is getting large and I would like to minimise it to desktop and use it when I need rather than it hovering in my face

Any pointers appreciated thank you great Gentlemen Coders :grinhalo:

DJ

dj44
02-18-2016, 01:34 PM
Hello Folks,

as luck would have it on my travels through the vba sphere, i have found Mr Colins Work :grinhalo:



https://colinlegg.wordpress.com/2015/10/29/minimize-and-maximize-userform-across-32-bit-and-64-bit-environments/

He has done the good work where it adds the minimise button.

If any one needs it - I tested it on word and excel - it sure will do the job.

thanks Mr Colin

This is a solved case.

DJ