#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default COMBOBOX

How do I select the first item that is in a combobox.

So far I've tried

combobox1 = combobox1.listindex(0)

and

combobox1 = combobox1.topindex

neither of these seem to work


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default COMBOBOX

Gregory,

Use

Combobox1.ListIndex = 0


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"GREGORY" wrote in message
...
How do I select the first item that is in a combobox.

So far I've tried

combobox1 = combobox1.listindex(0)

and

combobox1 = combobox1.topindex

neither of these seem to work




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
fill combobox depending on selection from another combobox Adam Francis Excel Discussion (Misc queries) 2 July 24th 08 07:39 PM
COMBOBOX smiley New Users to Excel 1 October 12th 05 02:01 PM
Combobox Aleks[_2_] Excel Programming 0 October 31st 03 06:58 PM
ComboBox cribeiro Excel Programming 0 October 31st 03 12:35 AM
combobox scrabtree23 Excel Programming 0 September 9th 03 01:42 PM


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

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

About Us

"It's about Microsoft Excel"