Afternoon chaps,
I have created a userform that I need to input data on one sheet in a workbook, but the data needs to be added to another worksheet.
I have created the userform and the code behind it but it will only add data to the sheet the userfom runs from.
I need to be able to add the data to the 'database' sheet.
Anyone tell me where I am going wrong, it would be much appreciated
Cheers
Ignore the attachment..... I will upload again once I have removed some code
Last edited by BigSpeekaz; 10-07-2014 at 06:39 AM.
Apologies.....
I have attached the corrected file
Maybe need to explain this another way
I have a control button for a userform on sheet 1. The information input into the userform needs to be added to the database on sheet 5.
Currently I can only add the data to sheet 1??
How do I direct VBA to add the data to sheet 5?
Bumping this..... I still need help guys! Thanks
The code is fine as long as 'database' sheet is the active sheet. Before you run the code behind the user form, your cursor should be on sheet database.
I have now amended the code that all values from the controls are written in to next empty row in sheet database.
Last edited by AB33; 10-10-2014 at 09:21 AM.
Thanks AB33
I understand what you are saying but want I want to achieve is to have the control button for the userform on a separate sheet. If at all possible I would like the database sheet to be hidden from view
Have you tried the amended code? You have a button on sheet introductory which opens the user form.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks