check list popup to update status

March 6, 2012 at 07:21:28
Specs: Windows XP, HP
Hi Team,

I have to update status completed in a cell, but before updating in the cell while i click on the cell one pop up with check box should appear to remind the task.

once we click the check box to conform that we are completed the task than it should allow to write status as completed.

Please help me to solve this issue.

Thanks in advance.

See More: check list popup to update status

Report •

March 8, 2012 at 19:37:00
if i understand this correctly, you should be able to write a macro using worksheet_change section. You will have to mention the range / cells where you need the action to be performed.
You could use something like...
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
Set rng = Intersect(Target, Range("B3"))
If rng is Nothing Then
Exit Sub
Dim cl as Range
For Each cl In rng
Next cl
End If
End Sub

Report •
Related Solutions

Ask Question