Userform Frame automatically adjust based on cell value

[Zimmerman]

Not sure if this is even possible, but I have a userform that has a width of 588 when fully viewed. What I'm wondering is when the user opens this I could have the width set at 150. And if in textbox2 they enter a 2 then the width of this frame will expand to 294. If the value entered in textbox 2 is 3 then this will expand to 438. if the value in textbox2 is 4 then it will expand to 588.

Thanks in advance
excel 2016

 

[Fluff]

How about

Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean)
   With Me.TextBox2
      If .Value < 5 And .Value > 0 Then
         Me.Width = Choose(.Value, 150, 294, 438, 588)
      End If
   End With
End Sub