User form

[michaelm702]

I have a excel which has 3 columns and each columns have some 8-10 values. I need a macro which will will have a user form on it and a combo box with entries "1,2,3". What I need is that once I select 1 from the combobox the user form should get populated with bottons which will have headers as the contents of collumn 1. Similarly if user selects 2 from combobox i need automatically buttons to appear on user from with caption as contents of column 2. Can you please guide or help achieve same.

[mdmackillop]

Try this.

[michaelm702]

thats good but I need buttons and besides every button we should have a checkbox if the checkbox is checked then the button below it should be clickable else not.

[michaelm702]

I need command buttons, will it work if I change the option button to command button. thanks mdmackillop (http://vbaexpress.com/forum/member.php?u=87) for quick reply

[Bob Phillips]

I have done it using a pseudo-control array for the checkboxes, and I added one for the commandbuttons. The buttons only display a message when pressed, you will need to add the real code.