Change userform label height without changing label width

So just found out autosize changes the width, which I don't want. I've got a label nested within a frame that allows the individual to view the body of the email they are currently working with and then hide it when the no longer require it.

Please Login or Register  to view this content.

I would like to make the AccessChange.EmailBody.Height dynamic without changing the width (PMCode).


Thanks in advance,


Janos

Hi Janos,

I've created a userform with a label on it and two buttons. One makes the height taller and the other shorter. Open up the code and see if it helps answer your question.

Was looking for something more automated like autosize without the width. There are already quite a manual steps in the process of this worksheet so I'm trying to eliminate some of the manual workload.

Any assistance with automating this task?

It looks like the "PMCode" you have in your VBS snippet above is a function or variable somewhere else in the code. Can you find and display how it is arrived at?

PMCode is the magical code that we have yet to create. I put it there for representation.

I'm having trouble dealing with the magic to get a real answer.

Originally Posted by MarvinP

I'm having trouble dealing with the magic to get a real answer.

Is this due to not understanding me (I can sometimes be a bit unclear sometimes I guess) or having a problem figuring out a solution?


If it is a misunderstanding, the PMCode is not set anywhere else in the subroutine. I put it there as an example of what I was trying to do.

Let me try doing it this way.

Please Login or Register  to view this content.