I have 3 worksheets, the first one contains data than has named ranges, the
second has combo boxes using these named ranges.

in the third i want to use combo boxes using the data from the first sheet.
how do i write the VBA programming to do this

hope someone out there can help

What do you want your comboboxes on third sheet to do with the data from the
first sheet?

The second sheet's comboboxes' code should give you some idea of how to code
comboboxes you add to the third sheet.

Have you looked it over yet?


Gord Dibben MS Excel MVP

On Wed, 17 Jun 2009 09:52:04 -0700, jeff
wrote:

I have 3 worksheets, the first one contains data than has named ranges, the
second has combo boxes using these named ranges.

in the third i want to use combo boxes using the data from the first sheet.
how do i write the VBA programming to do this

hope someone out there can help

hi Gord

I want the third sheet to show the same information the second one does,
this data is needed to perform a set of different calacutation.

"Gord Dibben" wrote:

What do you want your comboboxes on third sheet to do with the data from the
first sheet?

The second sheet's comboboxes' code should give you some idea of how to code
comboboxes you add to the third sheet.

Have you looked it over yet?


Gord Dibben MS Excel MVP

On Wed, 17 Jun 2009 09:52:04 -0700, jeff
wrote:

I have 3 worksheets, the first one contains data than has named ranges, the
second has combo boxes using these named ranges.

in the third i want to use combo boxes using the data from the first sheet.
how do i write the VBA programming to do this

hope someone out there can help