VBA Challenge - Flag Missing Info
Hi
why not use conditional formating. e.g. - select cell B1 - goto 'Format - Conditional format' - enter the formula =B1="" - choose a color -- Regards Frank Kabel Frankfurt, Germany "V-Man" schrieb im Newsbeitrag ... Hi all, I have a userform with various fields. Some fields are essential for a user to fill out. Before a user saves the form, I want to be able to flag the critical fields (maybe change their color) that have not been completed and generate a message which indicates the specific fields that need information. This is similar to when you fill out an application online and the missing info is highlighted before you can continue. I can give more details if you need! Thanks, V-Man |
All times are GMT +1. The time now is 10:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com