PC Review


Reply
Thread Tools Rate Thread

combobox in user form

 
 
bgkgmg
Guest
Posts: n/a
 
      27th Feb 2009
Having trouble writing code to fill my combobox in a user form I created.
I'm trying to fill cbobox with list in sheet1 C12:C24 Thanks
 
Reply With Quote
 
 
 
 
Eduardo
Guest
Posts: n/a
 
      27th Feb 2009
Hi,
Take a look at Debra web

http://www.contextures.com/xlDataVal11.html

"bgkgmg" wrote:

> Having trouble writing code to fill my combobox in a user form I created.
> I'm trying to fill cbobox with list in sheet1 C12:C24 Thanks

 
Reply With Quote
 
FSt1
Guest
Posts: n/a
 
      27th Feb 2009
hi
bring the form up in the vb editor. right click the combo box then click
properties.
scroll down the left side of the property box to rowsorce.
in the empty box to the right of rowsorce enter C12:C24.

regards
FSt1

"bgkgmg" wrote:

> Having trouble writing code to fill my combobox in a user form I created.
> I'm trying to fill cbobox with list in sheet1 C12:C24 Thanks

 
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
looking up data and using a combobox user form Paul Microsoft Excel Programming 6 25th Oct 2008 10:00 AM
User form ComboBox Items: Remember user entries? michelle.harshberger@gmail.com Microsoft Excel Programming 0 29th Mar 2007 06:41 PM
Re: Could not set the Text property of a ComboBox on User Form. NickHK Microsoft Excel Programming 2 13th Dec 2006 11:30 AM
RE: Could not set the Text property of a ComboBox on User Form. =?Utf-8?B?Sm9obiBCdW5keQ==?= Microsoft Excel Programming 0 11th Dec 2006 11:58 PM
VBA beginner needs assistance with ComboBox in a User Form Nufk@mp Microsoft Excel Misc 2 22nd Feb 2004 07:30 PM


Features
 

Advertising
 

Newsgroups
 


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