Ciao a tutti il mio Problema e questo : Io Vorrei sapere ; sempre che sia possibile.
Creare una Funzione in VBA che in Base a Determinati oggetti dello stesso tipo , mi dia la Possibilità di allungare o Restringere sempre in Altezza il mio Userform, Tutto qui.
Mi Spiego meglio :
1 ) Su di un Userform inserisco in Colonna 5 (Label e al loro fianco 5 Textbox) più Tre Tasti che saranno sempre solo quelli e non cambieranno mai la loro posizione.
2 ) Per qui per poter visualizzare il Contenuto del mio Userform avrò bisogno di scrivere nel campo Resize del mio Userform questo Codice :
Private Sub UserForm_Click()
Me.Height = 177
Me.Left = 0
Me.Top = 0
Me.Width = 307.5
End Sub
And so far nothing Eccezzionale.
3) But the basis of this kind of precondition what would happen if I aggiungessi other elements of the same type.
I would logically need a broader view of my userform to see everything.
For here and can create a function that in Base to the inserted objects can be amended accordingly auks the userform Thanks
Sincere Greetings to all and Happy Holidays
(P.S) I'm posting File Test
Hi Maurizio,
This is a forum with members from all corners of the world, we have to use a common language to understand eachother.
We expect a clear message, it's best to use Google Translate to provide clear information.
Thanks for understanding.
Catalin
Hi Maruzio
From what I can understand what you are saying using Google translate :), you want a form that will auto resize to fit the buttons, textbox etc. See if this will suit your needs.
Sunny
Sorry Maurizio, spelled your name wrongly.
Hello to all my name is Maurizio and I read very carefully your Post; But I can assure ch mine was a Clear Language and Especially in the English language.
But beyond this unfortunate technical inconvegnente that even I can not explain, my problem and this.
If you have downloaded my project and you Given a Glance, you'll surely realize that in Userform we Cone Of Label and Textbox Of the punsanti are Optional.
What matter most are always the (Label and TextBox)
Now in my Userform I, for greater speed I inserted only 10 objects here (5 of a kind and 5 of another thio)
then to better present all I imposed a certain greatness.
Having said that: For the ten items included the Width and Height size is fine what I put you and that is:
Private Sub UserForm_Click()
Me.Height = 177
Me.Left = 0
Me.Top = 0
Me.Width = 307.5
End Sub
Question: But if at the same Userform were added as other ggetti Those already Existing To further change the size of my Userform would dinuoco Forced to Change Manually These parameters Before Citati.
For here my Question Finale and then this, Added Other Items Nell'userform not there a method using VBA that performs this operation in Automatic mode is all thanks to all and Happy Holidays
Thanks SunnyKow I had read and seen chemi had already offered to you a file relating to my problem.
I gave her a glance, and I must say that you really Great, was just what I was trying to do me, Thank you very much and Happy Holidays to All Sincere Greetings From A.Maurizio
(P.S) Closed believe also this thread Thanks; Thank you ; Really thanks to All
