Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 40
Default combobox in user form

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,276
Default combobox in user form

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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,942
Default combobox in user form

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
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
looking up data and using a combobox user form Paul Excel Programming 6 October 25th 08 10:00 AM
User form ComboBox Items: Remember user entries? [email protected] Excel Programming 0 March 29th 07 06:41 PM
Adding to excel user form combobox Gimp Excel Programming 3 January 26th 07 05:02 PM
Could not set the Text property of a ComboBox on User Form. NickHK Excel Programming 2 December 13th 06 11:30 AM
Could not set the Text property of a ComboBox on User Form. John Bundy Excel Programming 0 December 11th 06 11:58 PM


All times are GMT +1. The time now is 09:37 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"