How can program to goto to the particular cell

[karthisucc9]

Hi All

I am new to Excel Programming. In my project i should display the 10 necessary items

in Listbox. When the user clicks the any one of the items in the list box it should

go to the particular cell.

How can i program it?could any one can help me

[NickyC]

Hi
without more details its a bit hard to tell, but ...
I'm assuming you have

a listbox called "list box 1" in your active worksheet
a range in the same worksheet which is the source list used in the worksheet
assigned macro listbox1_change to the listbox

if so, this macro will select the cell in your box's source range containing whatever item you choose in the listbox

Sub listbox1_change()
Dim rng, listval
rng = ActiveSheet.Shapes("List Box 1").ControlFormat.ListFillRange
listval = ActiveSheet.Shapes("List Box 1").ControlFormat.Value
Range(rng).Cells(listval).Select
End Sub