Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
User entry in cell creates popup
What I need to do is when the user enters certain values in a cell, they get
a flag to indicate that the item is on a list. We enter a lot of values in our Serial Number spreadsheet. There are certain values though, that need to get the users attention. I know how to do it directly from the cell, but that is too limited and awkward to change as these values will need to be updated from time to time. For instance, if the user enters "12345678" he will get a message, "This product requires an FAI!" I don't care how that works, i.e., popup or something in an adjacent cell. Any ideas how to do that? Thanks, Bryan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
User entry in cell creates popup
Let's say the serial numbers is entered in A1
The B1 could have formula =IF(A1=12345678,"Needs an FAI","") But that would limit you to seven 'notes' On another sheet make a table of serial numbers and their notes 12345678 This product requires an FAI 33333333 This product must be sent by air 45656754 This product explodes on contact with water Then on the main worksheet use a formula like =VLOOKUP(A1,Sheet2!A1:B50,2,FALSE) Note you will get a result of #N/A for serial numbers without an entry in the table best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bryan" wrote in message ... What I need to do is when the user enters certain values in a cell, they get a flag to indicate that the item is on a list. We enter a lot of values in our Serial Number spreadsheet. There are certain values though, that need to get the users attention. I know how to do it directly from the cell, but that is too limited and awkward to change as these values will need to be updated from time to time. For instance, if the user enters "12345678" he will get a message, "This product requires an FAI!" I don't care how that works, i.e., popup or something in an adjacent cell. Any ideas how to do that? Thanks, Bryan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
User entry in cell creates popup
Thanks! Worked great. I added some code to eliminate the #N/A:
=IF(ISNA(VLOOKUP(A29346,FAI!A1:B50,2,FALSE)),"",VL OOKUP(A29346,FAI!A1:B50,2,FALSE)) "Bernard Liengme" wrote: Let's say the serial numbers is entered in A1 The B1 could have formula =IF(A1=12345678,"Needs an FAI","") But that would limit you to seven 'notes' On another sheet make a table of serial numbers and their notes 12345678 This product requires an FAI 33333333 This product must be sent by air 45656754 This product explodes on contact with water Then on the main worksheet use a formula like =VLOOKUP(A1,Sheet2!A1:B50,2,FALSE) Note you will get a result of #N/A for serial numbers without an entry in the table best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bryan" wrote in message ... What I need to do is when the user enters certain values in a cell, they get a flag to indicate that the item is on a list. We enter a lot of values in our Serial Number spreadsheet. There are certain values though, that need to get the users attention. I know how to do it directly from the cell, but that is too limited and awkward to change as these values will need to be updated from time to time. For instance, if the user enters "12345678" he will get a message, "This product requires an FAI!" I don't care how that works, i.e., popup or something in an adjacent cell. Any ideas how to do that? Thanks, Bryan |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
User entry in cell creates popup
Thanks for the feedback
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bryan" wrote in message ... Thanks! Worked great. I added some code to eliminate the #N/A: =IF(ISNA(VLOOKUP(A29346,FAI!A1:B50,2,FALSE)),"",VL OOKUP(A29346,FAI!A1:B50,2,FALSE)) "Bernard Liengme" wrote: Let's say the serial numbers is entered in A1 The B1 could have formula =IF(A1=12345678,"Needs an FAI","") But that would limit you to seven 'notes' On another sheet make a table of serial numbers and their notes 12345678 This product requires an FAI 33333333 This product must be sent by air 45656754 This product explodes on contact with water Then on the main worksheet use a formula like =VLOOKUP(A1,Sheet2!A1:B50,2,FALSE) Note you will get a result of #N/A for serial numbers without an entry in the table best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bryan" wrote in message ... What I need to do is when the user enters certain values in a cell, they get a flag to indicate that the item is on a list. We enter a lot of values in our Serial Number spreadsheet. There are certain values though, that need to get the users attention. I know how to do it directly from the cell, but that is too limited and awkward to change as these values will need to be updated from time to time. For instance, if the user enters "12345678" he will get a message, "This product requires an FAI!" I don't care how that works, i.e., popup or something in an adjacent cell. Any ideas how to do that? Thanks, Bryan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation list that also allows user entry? | Excel Worksheet Functions | |||
Can a user select more than one entry in a drop down list? | Excel Worksheet Functions | |||
Auto email - With every new entry on my user form | Excel Discussion (Misc queries) | |||
Creating and Controlling a User data Entry Sheet | Excel Discussion (Misc queries) | |||
Data Entry Alert in User Form | Excel Discussion (Misc queries) |