ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   combobox in userform (https://www.excelbanter.com/excel-programming/391353-combobox-userform.html)

bernd

combobox in userform
 
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


George

combobox in userform
 
On Jun 14, 4:58 pm, bernd wrote:
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



All times are GMT +1. The time now is 12:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com