Userform Behaviour

[excelenergy]

Hello,

Ill post my simple code below - what Im really wondering is how I would do this (if its even possible)...Im using a userform and I have two checkboxes, a 'Yes' and 'No'..........Im wondering if the 'Yes' is checked I would like the userform to extend and another question to appear on the userform. If the No is checked, then the form doesnt have to do anything.

So this is what I got - was hoping someone could tell me how to make that happen, if its possible.

Thanks

Please Login or Register  to view this content.

[mehmetcik]

This is very simple.

All you have to do is to create your additional text boxes etc and modify their properties to make them invisible.

If you select yes then your code should then make them visible.

[excelenergy]

Didnt think of that. Ill give that a shot!

Thanks for your help. Ill post here if I have any further questions.

[mehmetcik]

This is very simple.

All you have to do is to create your additional text boxes etc and modify their properties to make them invisible.

If you select yes then your code should then make them visible.

Please Login or Register  to view this content.

[excelenergy]

The only thing Im in a bind with now is I need the command buttons to drop down to. At the end of the form I have a 'submit' button.

So I need those to move down as well. And right now I cant get it to. Any suggestions on that?

This is very simple.

All you have to do is to create your additional text boxes etc and modify their properties to make them invisible.

If you select yes then your code should then make them visible.

Please Login or Register  to view this content.

[mehmetcik]

Move your button to the top. It is easier that way.

[Andy Pope]

I enhanced mehmetcik example file.

You can change the position of controls within the Resize event.
Because the form now has a button present you need to toggle the visibility of the controls.

Please Login or Register  to view this content.

[excelenergy]

Fantastic! That worked beautifully!

Exactly what I needed. Really interesting though! Ive never done anything quite like this so it was neat to see how it could be done. The only thing I saw online was adding a class module and 1000 lines of code, and as you can imagine I decided against that haha!

Thanks andy!

I enhanced mehmetcik example file.

You can change the position of controls within the Resize event.
Because the form now has a button present you need to toggle the visibility of the controls.

Please Login or Register  to view this content.

[excelenergy]

Hey Andy,

I was just noticing this worked properly - except one thing. The first textbox at the top of my user form isnt aligned with the text on the left anymore...The text on the left is
"Name" < then textbox1 here >

after implementing this code it's moving the textbox so it looks more like this:

"Name:"


<textbox1 is down here>

Any ideas why that could be? Other than that - everything works perfectly.

Fantastic! That worked beautifully!

Exactly what I needed. Really interesting though! Ive never done anything quite like this so it was neat to see how it could be done. The only thing I saw online was adding a class module and 1000 lines of code, and as you can imagine I decided against that haha!

Thanks andy!

[excelenergy]

Hey Andy,

Dont worry, I fixed it, I had to set this right here:

Please Login or Register  to view this content.

Doing that, it made sure it was all re-aligned.