Disable/make invisible command button on userform when table created

Hi All

I have a problem in my project which I have searched for aa solution to and came up with this thread

http://www.excelforum.com/excel-prog...has-value.html


I cannot seem to make it work for my userform

The button in question is Commandbutton3 on frmmemb which creates a table when the first entry is submitted

I would ideally like to make this button invisible or deleted forever after it has been used

can anyone shed some light on this please

regards Moose

I worked it out

I put the code in the wrong place

now it behaves itself

thanks to those who took a peek though

Check if the table has been created when loading the userform, and hide/not hide accordingly.

Please Login or Register  to view this content.

You still need to hide it once the table is created in code - I didn't take the time to try and find where that is...

Thanks

I put one button over another and hid the one which created the table
then the other button can resume normal service