Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing info on worksheet | Excel Worksheet Functions | |||
Pivot - top 10 stocks & missing info | Excel Worksheet Functions | |||
When merging to Word, some info from cell missing? | Excel Discussion (Misc queries) | |||
Missing info in Formula Tab | Excel Discussion (Misc queries) | |||
Legend Missing Info | Charts and Charting in Excel |