RunTime error with UserForm!.Show

**j_Southern** · 05-03-2011, 06:25 AM

Dear Forum Members
I have a userform with a commandbutton to open a second UserForm

Please Login or Register  to view this content.

This was working normaly till this morning when I got the following message
Run Time Error 70
Permission denied.
The suggestions in the help files don't seem relevant so I am stuck. The application files are all on my local disc so I don't think network permissions are involved. Can any one point me in the right direction?
Thanks
John

**davesexcel** · 05-03-2011, 06:27 AM

That is not the problem.
The UserForm is the problem. Lets see the userform code.
Chances are you are trying populate a control two ways.

**j_Southern** · 05-03-2011, 06:47 AM

Davesexcel,
I was changing the way I populated a Listbox so it is possible I didn't remove the old way. I will check this out and either change the post to solved or come back with the userform coding.
Thanks for your help
John

**j_Southern** · 05-03-2011, 07:29 AM

Davesexcell,
This is the code for the userform throwing the error message

Please Login or Register  to view this content.

I have checked and can find no sign of th earlier code I used to populate ListBox1

I hope this helps to pin point the problem
John

**davesexcel** · 05-03-2011, 07:46 AM

Could you have used the properties window?

**royUK** · 05-03-2011, 07:54 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Have you renamed CommandButtons from CommandButton2 to CB2?

**Andy Pope** · 05-03-2011, 08:10 AM

You can get the Err #70 Permission denied when trying to set the list property of a listbox that already has the Rowsource property set.

**snb** · 05-03-2011, 08:24 AM

I fear that the userform's codename that contains the button to open the second userform is identical to the userform's codename you want to open with the button.

Please Login or Register  to view this content.

I'd prefer to call a second userform (if fantasy is lacking) userform2

**j_Southern** · 05-03-2011, 09:42 AM

DavesExcel,RoyUK,AndyPope,snb et al

Thanks for your help, you got there for me! I had the RowSource property set to a range and also set the value in code in the userform_initialise proceedure.

Its working properly now, many thanks
John