Sabrina has attended:
Excel Advanced course
VBA changes on existing form
Dear Sirs,
A previous colleague has created a form with some defined boxes and macro behind linked to the form for allowance of revenue purposes.
I was hoping to amend the form rather than re-create the form by replacing name of the boxes by relevant names and deleting the not in use boxes. I have done this successfuly on the design of the forms.
However when I load the form, an error message comes up with " compile error method or data member not found". It is highlighting in yellow one part of the macro.
I wonder whether you could highlight me with some help ? Or maybe I could email you the document. I am booked on a VBA class mid December but was hoping to deal with this before.
Regards
Sabrina
RE: VBA changes on existing form
Hi Sabrina
Yes it would help if you could email your document to info@stl-training.co.uk
Thanks
Doug Dunn
Best STL
RE: VBA changes on existing form
Thank you Doug.
I have just emailed you the document.
Hopefully you received it.
Best regards
Sabrina
RE: VBA changes on existing form
Thanks Sabrina
I received your 2 documents and will get back to you as soon as I can.
Regards
Doug
Best STL
RE: VBA changes on existing form
Hi Sabrina
Sorry for not getting back sooner.
I've had a look at your form today. The reason you are getting the error "compile error method or data member not found" on the Allowance Form A is because the code is referencing Textbox7. This doesn't exist and I think is the Reason for Allowance box added to the Business centre rev file.
So in the Allowance Form A workbook you need to remove any reference to Textbox7, for example Or Me.textbox7 = "".
Also comment out the procedure Textbox7_change()
To find a control such as Textbox7 -
In the vb editor
Double click on Userform1
In the Properties window click the drop down to view all controls
Then whichever one you click becomes selected on the form.
Hope that helps for the moment.
Regards
Doug Dunn
Best STL
