Return action when a selected cell has focus.
 

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

Return action when a selected cell has focus.
 

When cell A8 (Range("A8").Select) is selected, a
designated Combo Box is visible.

I didnot understand what is designated Combo Box. How did you add th
combo box? please explain in detai

--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=31937

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

Return action when a selected cell has focus.
 

select the cell

from the Data Menu Validation

select "Lists" in Allow

Then in Source specify the range of values to be displayed in th
combobo

--
srpar
-----------------------------------------------------------------------
srparr's Profile: http://www.excelforum.com/member.php...fo&userid=1673
View this thread: http://www.excelforum.com/showthread.php?threadid=31937