SOLVED
Home

Aid data entry or mandatory cells prompt when a cell is filled

%3CLINGO-SUB%20id%3D%22lingo-sub-307701%22%20slang%3D%22en-US%22%3EAid%20data%20entry%20or%20mandatory%20cells%20prompt%20when%20a%20cell%20is%20filled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307701%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20looking%20for%20someone%20to%20assist%20me%20with%20my%20excel%20project.%20I%20want%20a%20pop%20form%20to%20appear%20when%20a%20cell%20is%20selected%2C%20to%20assist%20enter%20data%20in%20that%20cell%20and%20several%20other%20specific%20cells%2C%20either%20in%20that%20worksheet%20or%20other%20sheets%20within%20the%20same%20workbook.%20Or%20create%20a%20series%20of%20promting%20messages%20requiring%20completion%20of%20few%20other%20cells%20if%20a%20certain%20cell%20is%20filled%2C%20or%20something%20similar%20to%20prompt%20users%20to%20fill%20in%20multiple%20data%20in%20different%20locations%20using%20just%20one%20form.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-307701%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321481%22%20slang%3D%22en-US%22%3ERe%3A%20Aid%20data%20entry%20or%20mandatory%20cells%20prompt%20when%20a%20cell%20is%20filled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321481%22%20slang%3D%22en-US%22%3EHi%20Rich%2C%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20makes%20perfect%20sense.%20I%20will%20try%20it%20some%20day.%20I%20managed%20by%20equating%20the%20adjacent%20cell%20with%20the%20empty%20string(%22%22).%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20the%20timeous%20response.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321302%22%20slang%3D%22en-US%22%3ERe%3A%20Aid%20data%20entry%20or%20mandatory%20cells%20prompt%20when%20a%20cell%20is%20filled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321302%22%20slang%3D%22en-US%22%3EI%20think%20this%20should%20do%20it%2C%20just%20change%20cell%20reference%20as%20required%3CBR%20%2F%3E%3DIF(AND(A1%3D%22%22%2CA4%3D%22%22)%2C%22%22%2CIF(AND(A1%26gt%3B0%2CA4%3D%22%22)%2CA1%2CA4))%3CBR%20%2F%3E%3CBR%20%2F%3ERich%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321147%22%20slang%3D%22en-US%22%3ERe%3A%20Aid%20data%20entry%20or%20mandatory%20cells%20prompt%20when%20a%20cell%20is%20filled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321147%22%20slang%3D%22en-US%22%3EHi%20Rich%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20timeous%20response.%20I%20bet%20what%20I%20want%20to%20achieve%20is%20too%20complex%20for%20build-in%20excel%20functions.%20I'm%20leaving%20it%20for%20a%20while.%3CBR%20%2F%3E%3CBR%20%2F%3EBy%20the%20way%2C%20May%20you%20kindly%20assist%20me%20with%20a%20formula%20that%20will%20return%20a%20date%20in%20one%20cell%20from%20two%20cells%20depending%20on%20which%20cell%20is%20filled.%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20instance%2C%20a%20date%20should%20be%20returned%20in%20Sheet2%20A7%20from%20sheet1%20A1%20if%20sheet1%20A4%20is%20empty%20(no%20date%20filled)%20or%20from%20sheet1%20A4%20if%20sheet1%20A1%20is%20empty(no%20date%20filled)%20else%20return%20an%20empty%20cell%20if%20both%20(Sheet1%20A1%20and%20A4)%20are%20empty.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309720%22%20slang%3D%22en-US%22%3ERe%3A%20Aid%20data%20entry%20or%20mandatory%20cells%20prompt%20when%20a%20cell%20is%20filled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309720%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20all%20this%20be%20achieved%20by%20using%20data%20validation%20rather%20than%20a%20macro%3F%20You%20would%20be%20able%20to%20set%20the%20values%20for%20the%20cell%2C%20have%20an%20input%20message%20when%20the%20user%20selects%20the%20cell%20and%20have%20an%20error%20alert%20if%20invalid%20data%20is%20entered.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERich%3C%2FP%3E%3C%2FLINGO-BODY%3E
Mwandingi_03
Occasional Contributor
Hi,

I'm looking for someone to assist me with my excel project. I want a pop form to appear when a cell is selected, to assist enter data in that cell and several other specific cells, either in that worksheet or other sheets within the same workbook. Or create a series of promting messages requiring completion of few other cells if a certain cell is filled, or something similar to prompt users to fill in multiple data in different locations using just one form.

Thank you.
4 Replies
Solution

Hi,

 

Could all this be achieved by using data validation rather than a macro? You would be able to set the values for the cell, have an input message when the user selects the cell and have an error alert if invalid data is entered.

 

Rich

Hi Rich

Thank you for your timeous response. I bet what I want to achieve is too complex for build-in excel functions. I'm leaving it for a while.

By the way, May you kindly assist me with a formula that will return a date in one cell from two cells depending on which cell is filled.

For instance, a date should be returned in Sheet2 A7 from sheet1 A1 if sheet1 A4 is empty (no date filled) or from sheet1 A4 if sheet1 A1 is empty(no date filled) else return an empty cell if both (Sheet1 A1 and A4) are empty.

Thank you.
I think this should do it, just change cell reference as required
=IF(AND(A1="",A4=""),"",IF(AND(A1>0,A4=""),A1,A4))

Rich
Hi Rich,

This makes perfect sense. I will try it some day. I managed by equating the adjacent cell with the empty string("").

Thank you for the timeous response.