View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Return action when a selected cell has focus.

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