PC Review


Reply
Thread Tools Rate Thread

Combobox rowsource from non-contiguous cells

 
 
Gig
Guest
Posts: n/a
 
      10th Apr 2009
I've looked all over trying to find a solution for this, but no luck
yet.

I would like to set a userform combobox with a rowsource from three
non-contiguous cells, ie., m33, m37, m38. Does anyone know if this is
even possible?

Thanks,
Greg
 
Reply With Quote
 
 
 
 
Mike H
Guest
Posts: n/a
 
      10th Apr 2009
Hi,

Do it programatically when the userfrom loads

Private Sub UserForm_Activate()
With ComboBox1
.AddItem Range("M33").Value
.AddItem Range("M37").Value
.AddItem Range("M38").Value
End With

End Sub


Mike

"Gig" wrote:

> I've looked all over trying to find a solution for this, but no luck
> yet.
>
> I would like to set a userform combobox with a rowsource from three
> non-contiguous cells, ie., m33, m37, m38. Does anyone know if this is
> even possible?
>
> Thanks,
> Greg
>

 
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
ComboBox RowSource Caleb Runnels Microsoft Excel Programming 4 22nd Jul 2007 10:47 PM
combobox rowsource J Holtendehouzer Microsoft Access Queries 1 6th Apr 2006 05:04 AM
Combobox rowsource based on value of other combobox =?Utf-8?B?UmljaCBK?= Microsoft Access Form Coding 0 9th Nov 2004 10:15 PM
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox Minitman Microsoft Excel Programming 3 26th Oct 2004 07:58 PM
Re: Combobox rowsource Larry Daugherty Microsoft Access 8 21st Sep 2004 08:40 PM


Features
 

Advertising
 

Newsgroups
 


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