Why is there a space at the bottom when the UserForm is on fullscreen

Bendfella · Mar 26th 2020

Hi to all

I know this topic has been exhausted over the internet but maybe i missed something.

is there no way i can get rid on the blank space at the bottom of this userform when it loads.

here is the picture and code i use ( i used a lot of them to try)

Code

Private Sub UserForm_Initialize()

  With Application
  .WindowState = xlMaximized
  Zoom = Int(.Width / Me.Width * 100)
  Width = .Width
  Height = .Height
  End With


<img src="https://www.ozgrid.com/forum/core/index.php?attachment/1227532-userform-pic-png/" class="woltlabAttachment" data-attachment-id="1227532" id="wcfImgAttachment0">

Display More

**royUK** · Mar 26th 2020

This works for me in the activate event of the form

Code

Option Explicit


Private Sub UserForm_Activate()


''//   Adjust UserForm to Excel's window size
With Me
.Height = Application.Height
.Width = Application.Width
.Left = Application.Left
.Top = Application.Top
End With
End Sub

Display More

Bendfella · Mar 26th 2020

i tried that one also, it does not work. still leaves a big space under the last textboxes.

Anyway thank you

**royUK** · Mar 26th 2020

It works OK for me. It must be something else in your seetings. Can you attach the workbook.

Bendfella · Mar 26th 2020

ok i will just remove sensitive information

**royUK** · Mar 26th 2020

That fills my whole screen. The Taskbar is visible unless I hide it then only the form is visible

Bendfella · Mar 27th 2020

Hi Roy

the problem is that we don't READ all the time.

u were right. i had the code in my "Initialize" event. I now put in it the "Userform Activate" event. Its working now as you said.

This thread is SOLVED now. Thank you

**royUK** · Mar 27th 2020

Pleased to help

Why is there a space at the bottom when the UserForm is on fullscreen

Participate now!

Share