Paul,
Use the SelectionChange event of the worksheet. In the
appropriate sheet's code module, use code like the following:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$8" Then
' do something
End If
End Sub
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Paul" wrote in message
...
Hello All,
Code is needed to call a Combo box when a selected cell has
focus.
For example;
When cell A8 (Range("A8").Select) is
selected, a
designated Combo Box is visible.
What is the code to perform this task?
Thanks
Paul