Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to EXTEND listbox entries

How to EXTEND the ListBox entries after once implemented 10 items in the
list...
now i wisht o add more items into it...

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 414
Default How to EXTEND listbox entries

maybe:

listbox1.additem "something else"

Regards
Rowan

Ulhas wrote:
How to EXTEND the ListBox entries after once implemented 10 items in the
list...
now i wisht o add more items into it...

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default How to EXTEND listbox entries

Use the AddItem method to add items to the end of the list. E.g.,

UserForm1.Listbox1.AddItem "abc"


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



"Ulhas" wrote in message
...
How to EXTEND the ListBox entries after once implemented 10
items in the
list...
now i wisht o add more items into it...



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
How can I extend the filtering limits of 1000 unique entries ianshoey Excel Discussion (Misc queries) 1 March 16th 06 01:15 AM
How to extend the no' of displayed entries in a drop down list SlowDriver Excel Discussion (Misc queries) 0 March 1st 06 09:51 AM
create entries on a listbox on a form Grd Excel Programming 1 March 28th 05 09:55 PM
How do I return the unique entries from a column to a listbox Dave Mc Excel Worksheet Functions 4 February 9th 05 08:02 AM
listbox.value not equal to listbox.list(listbox.listindex,0) ARB Excel Programming 0 October 22nd 03 12:46 AM


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