Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
requiring a field
Say I have a drop down list in A2 where you can choose yes or no, if you
choose no I want b2 to require notes to be entered...How would I require this? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
requiring a field
You could have a formula in C2 =IF(A2="no", "Be sure to fill in B2","")
Or you could have event code that popped up a message. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Intersect(Target, Me.Range("A2")) Is Nothing Then Exit Sub On Error GoTo CleanUp Application.EnableEvents = False With Target If .Value = "no" Then MsgBox "Please fill in cell B2" End If End With CleanUp: Application.EnableEvents = True End Sub Note......both of these are reminders only and if users choose to ignore the messages or disable macros.................then what? Gord Dibben MS Excel MVP On Mon, 10 Jul 2006 07:59:02 -0700, cherrynich wrote: Say I have a drop down list in A2 where you can choose yes or no, if you choose no I want b2 to require notes to be entered...How would I require this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create formula. 1 field constant and another field varies by inpu. | Setting up and Configuration of Excel | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Pivot Tables..I give up... | Excel Worksheet Functions |