Does any know a VBA to make colums mandatory,
What i want is a VBA that, if a user enters information into cell B2 then they have to enter information into C2 D2 and E2 and if the try and save it without this information an error message pops up. But the same if they try and enter information into C2 - B2 D2 and E2 need to be populated. is this possable?
Please let me know if this is not clear?
snoopy1461,
For forcing that data be entered or not entered, its best to protect the sheet and then have a userform for data entry. Attached is an example. The worksheet protection password is: 123
Hope that helps,
~tigeravatar
Last edited by tigeravatar; 06-21-2011 at 01:44 PM. Reason: Commented code in sample workbook
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks