Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a list that has the following columns:
A = PO Number B= Status C= Description D= Sup. Sig E= Fin. Sig G= Man Sig H=Pur Sig I want to know if there's a Macro or something I could create that if Colum B is filled with "Aproved" it checkes that columns D-E-F-G-H have a value and if blank ask for the value to fill it in automatically not just do a prompt requesting that the person fill it in manually. For example that a dialoge box would pop-up with something like "Please Provide Sup. Sig: [Input Box here]" and when entered column D would be filled with the input provided by the user. Thank you for your help. -- Gabriel Camarena R. Delphi Tijuana IT Support |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting a prompt to automatically fill a cell | Excel Discussion (Misc queries) | |||
VBA for prompt to fill in the certain cell | Excel Programming | |||
How prompt Excel user to fill cell with text, i.e., proposal name | Excel Discussion (Misc queries) | |||
Prompt before updating values | Excel Worksheet Functions | |||
User Prompt to Confirm Values | Excel Programming |