PC Review


Reply
Thread Tools Rate Thread

combobox in userform

 
 
bernd
Guest
Posts: n/a
 
      14th Jun 2007
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

 
Reply With Quote
 
 
 
 
George
Guest
Posts: n/a
 
      15th Jun 2007
On Jun 14, 4:58 pm, bernd <bernd.vd.b...@gmail.com> 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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
userform combobox Jonathan Microsoft Outlook VBA Programming 1 25th May 2010 02:32 AM
Userform w/ComboBox =?Utf-8?B?RC5QYXJrZXI=?= Microsoft Excel Misc 2 6th May 2005 04:28 PM
Combobox in userform =?Utf-8?B?QWx2aW4gSGFuc2Vu?= Microsoft Excel Programming 6 9th Aug 2004 12:19 PM
ComboBox on UserForm Michel Microsoft Excel Programming 3 1st Aug 2004 11:10 PM
ComboBox on UserForm Michel Microsoft Excel Programming 2 31st Jul 2004 10:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:51 AM.