More combobox questions

lc · Sep 6, 2005

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

Reply

Tom Ogilvy Sep 1, 1:27 pm show options

Newsgroups: microsoft.public.excel.programming
From: "Tom Ogilvy" <[email protected]> - Find messages by this author
Date: Thu, 1 Sep 2005 14:27:06 -0400
Local: Thurs, Sep 1 2005 1:27 pm
Subject: Re: Combobox question
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse

In the linkedcell property

Sheet1!A1

would like the combobox to cell A1 on Sheet1.

--
Regards,
Tom Ogilvy

- Hide quoted text -
- Show quoted text -

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.

lc

Reply

lc Sep 1, 1:51 pm show options

Newsgroups: microsoft.public.excel.programming
From: "lc" <[email protected]> - Find messages by this author
Date: 1 Sep 2005 11:51:14 -0700
Local: Thurs, Sep 1 2005 1:51 pm
Subject: Re: Combobox question
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

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.

Reply

Tom Ogilvy Sep 1, 2:38 pm show options

Newsgroups: microsoft.public.excel.programming
From: "Tom Ogilvy" <[email protected]> - Find messages by this author
Date: Thu, 1 Sep 2005 15:38:50 -0400
Local: Thurs, Sep 1 2005 2:38 pm
Subject: Re: Combobox question
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse

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

- Hide quoted text -
- Show quoted text -

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.

Reply

lc Sep 6, 9:40 am show options

Newsgroups: microsoft.public.excel.programming
From: "lc" <[email protected]> - Find messages by this author
Date: 6 Sep 2005 07:40:51 -0700
Local: Tues, Sep 6 2005 9:40 am
Subject: Re: Combobox question
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

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 · Sep 6, 2005

Option Base 1

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

Private Sub Combobox2_Click()
Dim v as Variant
v = Array("Sheet3","Sheet4","Sheet5","Sheet10")
if combobox1.listindex <> -1 then
Worksheets(v(combobox.ListIndex + 1)).Activate
end if
End Sub

--
Regards,
Tom Ogilvy

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

Reply

Tom Ogilvy Sep 1, 1:27 pm show options

Newsgroups: microsoft.public.excel.programming
From: "Tom Ogilvy" <[email protected]> - Find messages by this author
Date: Thu, 1 Sep 2005 14:27:06 -0400
Local: Thurs, Sep 1 2005 1:27 pm
Subject: Re: Combobox question
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse

In the linkedcell property

Sheet1!A1

would like the combobox to cell A1 on Sheet1.

--
Regards,
Tom Ogilvy

- Hide quoted text -
- Show quoted text -

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.

lc

Reply

lc Sep 1, 1:51 pm show options

Newsgroups: microsoft.public.excel.programming
From: "lc" <[email protected]> - Find messages by this author
Date: 1 Sep 2005 11:51:14 -0700
Local: Thurs, Sep 1 2005 1:51 pm
Subject: Re: Combobox question
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

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.

Reply

Tom Ogilvy Sep 1, 2:38 pm show options

Newsgroups: microsoft.public.excel.programming
From: "Tom Ogilvy" <[email protected]> - Find messages by this author
Date: Thu, 1 Sep 2005 15:38:50 -0400
Local: Thurs, Sep 1 2005 2:38 pm
Subject: Re: Combobox question
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse

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

- Hide quoted text -
- Show quoted text -

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.

Reply

lc Sep 6, 9:40 am show options

Newsgroups: microsoft.public.excel.programming
From: "lc" <[email protected]> - Find messages by this author
Date: 6 Sep 2005 07:40:51 -0700
Local: Tues, Sep 6 2005 9:40 am
Subject: Re: Combobox question
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

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

Putting a formula in place one time for the entire spreadsheet	2	Aug 2, 2005
IF Statement not Displaying FILLDOWN results Automatically	3	Aug 11, 2005
Show/Select Visible Rows via ComboBox	3	Mar 11, 2007
Data Validation - Combo Box open with single click	0	Oct 9, 2009
Validation Rules in Tables	3	Sep 28, 2005
Combo List on the form (Version 2)	1	Sep 14, 2007
ComboBox on a Sheet	3	Jan 30, 2006
Search Form	1	Dec 7, 2005

More combobox questions

lc

Tom Ogilvy

Ask a Question

Similar Threads