Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 62
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combobox userform help please Chris Excel Programming 1 October 20th 06 04:36 AM
combobox and userform help! dawn Excel Programming 3 October 11th 06 02:08 AM
Combobox in userform Alvin Hansen[_2_] Excel Programming 6 August 9th 04 12:19 PM
ComboBox on UserForm Michel[_4_] Excel Programming 3 August 1st 04 11:10 PM
ComboBox on UserForm Michel[_4_] Excel Programming 2 July 31st 04 10:11 PM


All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"