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

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

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

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