I want to scan in data in my first column, and then have the date and time auto fill in the next two columns. So basically, if a value exists in Column A, I want Column B to auto Populate the date and Column C to auto populate the time. I also want the date and time to be locked so that the cells cannot be edited. (only taken out by deleting the first row which was scanned in) Does anyone know how I can do this? I am new to Excel and will be taking some advanced courses soon.
Right Click on the sheet name at the bottom of excel and select view code
Paste this code ion the module that opens
Close the module
Type in a number in column A
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
VBA would allow for this, as I don't think a simple formula can lock down a date and time as shown above.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Thank you so much. I have one more question if you don't mind. How do you lock the cell so that they cannot edit the date and time?
Thanks again!
That is easily done
Make it so the user cannot select columns B or C.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks