Please take a look at the attached workbook. I'm trying to create a userform that will add employees to a hidden worksheet. I've seen this done before but the Excel file is locked and password protected so I can't see the code. I basically need it to add an employee to an existing hidden sheet (as well as be able to delete). It'll make more sense when you take a look at the workbook and see the existing userforms I've created. The last two command buttons on the "Revenue Forecast" sheet only show the userform, those userforms don't work yet which is what I'm trying to figure out.
The passwords are "123" for anything that requires a password. Any help at all is appreciated.
Thanks in advance!
Last edited by SoCalRizzy; 08-11-2008 at 02:49 PM.
I guess I can't attach the file because its too big. I can email it to whomever can take a look at it, just reply or PM with an email address.
Good evening SoCalRizzy
Have a look at this workbook - it's a userform that creates a simple contacts database on a visible page, but the technique is the same. All the code is unlocked and available for viewing.
HTH
DominicB
Here, I compressed the file...
Anybody had a chance to look at this and have any suggestions? I've racked my brain for 2 days now and I'm getting no where.
Hi SoCalRizzy
- You still haven't actually uploaded a file.
- You haven't had the good grace to respond to, or even acknowledge the one reply you have got.
DominicB
DominicB,
I apologize for not responding to your previous post. I did take a look at it and it does exactly what I need it to do for creating a new line item every time I want to create a new employee record. Thank you for that. Now I have to work with it to incorporate it into my existing sheet. I'm not very good at any of this VBA programming and I'm learning as I go so it takes a little time for me to understand the code.
And sorry about the file attachment. I'm not sure what is going on with it. I noticed the first couple of times the file was too big so I tried compressing it and I thought the last time it worked. I guess it didn't. So once again, I shall try again.
Thank you again for any and all help.
Regards,
JR
Originally Posted by dominicb
Hi SoCalRizzy
I have added some code into your userform that will make your worksheet visible, add the information and then hide it again, as you can't do it with the sheet remaining very hidden as it is. I've also change your tick boxes to option buttons, as a user could erronously tick both boxes, but with option buttons the default behaviour is to select one only.
The code I've added needs tidying a little - what I've done so far just puts you on the right road. Try compariong it to the workbook I posted earlier to see the similarities in the two.
HTH
DominicB
Last edited by dominicb; 08-19-2008 at 04:31 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks