Hi,

I am trying to create a combo box such that when I select a value from
the combo box, it will link me to a cell I had specified.

I am also trying to create another combo box such that when I select a
value from the combo box, it will link me to another worksheet of the
same workbook.

Any help is greatly appreciated.

Thanks.

lc

In the linkedcell property

Sheet1!A1

would like the combobox to cell A1 on Sheet1.

--
Regards,
Tom Ogilvy

"lc" wrote in message
oups.com...
Hi,

I am trying to create a combo box such that when I select a value from
the combo box, it will link me to a cell I had specified.

I am also trying to create another combo box such that when I select a
value from the combo box, it will link me to another worksheet of the
same workbook.

Any help is greatly appreciated.

Thanks.

lc

What I really want to do is to link each selection with a differenct
cell. For example, if my input range consists of the following
information:

1. a
2. b
3. c
4. d

The cells I want my selection to link to is:

1. C100
2. A20
3. D40
4. F50

When I select "a" from the combo box, it will go to the cell C100.
When I select "b" from the combo box, it will go to cell A20.
etc.

I hope this clarifies my question

Thanks.

Private Sub Combobox1_Click()
Dim v as Variant
v = Array("C100","A20","D40","F50")
if combobox1.listindex < -1 then
Range(v(combobox.ListIndex + 1)).Select
end if
End Sub

--
Regards,
Tom Ogilvy

"lc" wrote in message
oups.com...
What I really want to do is to link each selection with a differenct
cell. For example, if my input range consists of the following
information:

1. a
2. b
3. c
4. d

The cells I want my selection to link to is:

1. C100
2. A20
3. D40
4. F50

When I select "a" from the combo box, it will go to the cell C100.
When I select "b" from the combo box, it will go to cell A20.
etc.

I hope this clarifies my question

Thanks.

Hi,

I was wondering what the code would be if I want it to select sheets
instead of cells. I have tried changing "C100, A20, D40, F50" to the
sheet names but it did not work.

Any help would be greatly appreciated.

Thanks.

lc
Tom Ogilvy wrote:
Private Sub Combobox1_Click()
Dim v as Variant
v = Array("C100","A20","D40","F50")
if combobox1.listindex < -1 then
Range(v(combobox.ListIndex + 1)).Select
end if
End Sub

--
Regards,
Tom Ogilvy

"lc" wrote in message
oups.com...
What I really want to do is to link each selection with a differenct
cell. For example, if my input range consists of the following
information:

1. a
2. b
3. c
4. d

The cells I want my selection to link to is:

1. C100
2. A20
3. D40
4. F50

When I select "a" from the combo box, it will go to the cell C100.
When I select "b" from the combo box, it will go to cell A20.
etc.

I hope this clarifies my question

Thanks.