• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Code for UserForm

B

bfraser

Member
I have a small spreadsheet w/1700 rows of Assets ("Unit #). Column C is "Unit #", Col O is "PM Comp Date" col. Q is "Technician". The UserForm has 3 text boxes for the user to enter Unit #,PM Comp Date and Technician and also has two command buttons; 1 to Update Asset data and one to close the User form. Can I get some help w/code to update each Assets Pm Comp Date (col O) and the Technician (col. Q) based on what the user enters into the Unit # text box on the UserForm.
 
Have you looked at a database for this sort of thing rather than Excel?


You could do it in Access fairly easily (with a form and a recorset) and link the data back in to Excel for reporting.


I would try to keep away from using Excel as a database (which imo it sounds like you're doing)
 
Unfortunately, Access for Dummies is on my Christmas list and may even be over my head, as far as Access goes.
 
Wouldn't Access be a little over kill for a data that wouldn't be used anywhere else, i.e. in a relational database. Just tracking when an asset has preventive maintenance performed on it.
 
You must log in or register to reply here.
Back
Top