Using command buttons vba in frame in excel 2010

[brewsi]

Hi guys thanks for reading this. Does any one know how to write vba code for a command button in a frame on a userform. When i double click the command button after creating the object in a frame nothing happens and when i right click it the view code is greyed out. I have tried reference the command button but nothing works can anyone please help

Thabks in advance

[Norie]

You should be able to create code for a button in a frame in the same way as one not in a frame.

What happens it you manually add code like this.

Please Login or Register  to view this content.

[brewsi]

Hi norie thanks for your reply. It wont let you put a code for the button i have tried the code you suggested in the userform initialze sub but nothing happens

[Norie]

The code I posted is a sub in itself, it would go in tge userform module.

The only thing you need to do is to change buttonname to the actual name of the button in the frame.

[brewsi]

Ok norie ill give that a go tomorrow thanks for your help