combobox in userform

B

bernd

Hello,

I've a sheet with data in column A and in row 2.
I want to use a userform with a combobox to let the application go to
the cell in row 2 that has the same value as selected in the combobox.

The datasource for the combobox is in column A.

Is this possible? How?

Thanks,

Bernd
 
G

George

Hello,

I've a sheet with data in column A and in row 2.
I want to use a userform with a combobox to let the application go to
the cell in row 2 that has the same value as selected in the combobox.

The datasource for the combobox is in column A.

Is this possible? How?

Thanks,

Bernd

Hi:

Define your datasource as a name, then put this name in the RowSource
properties within the userform.

Hope this works.

George
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top