I would like to change the look of my userform runtime. I have a userform and depending on which value you choose from some comboboxes the layout should change. I do that by applying the changes in the
"Sub combobox_Change()", but I still cant find out how to add a checkbox or a textbox........can change the height and the position of existing elements, but not creating new ones?
I am quite new to VBA, so it probably has to be quite well explained :thanx:
I had a similar post ealier but I do not think it was clear that I meant runtime....
Below is a a little paste of this part of my code where I want the changes to appear:
Private Sub cmbStrategy_Change() If frmNewswap.cmbStrategy.Value = "Pair" Then frmNewswap.Height = 500 Else frmNewswap.Height = 400 End If End Sub
Thanks in advance.....