Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 371
Default Access items stored in combobox

Hello

I have a combobox (from control toolbox) with items in it from a list, which
needs to be updated. How can I access the list? There doesn't seem to be
anything under properties that corresponds to the range the combobox is
reading off.

--
There are 10 types of people in the world - those who understand binary and
those who don't.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 371
Default Access items stored in combobox

Actually, don't worry - I found the property 'ListFillRange'. Guess I
couldn't see for looking...
--
There are 10 types of people in the world - those who understand binary and
those who don't.


"Geoff" wrote:

Hello

I have a combobox (from control toolbox) with items in it from a list, which
needs to be updated. How can I access the list? There doesn't seem to be
anything under properties that corresponds to the range the combobox is
reading off.

--
There are 10 types of people in the world - those who understand binary and
those who don't.

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
formatting the list items for ComboBox created using Forms Desmond Excel Discussion (Misc queries) 3 May 4th 06 10:04 AM
can't sum up items i cut&paste from access to excel.. caroline Excel Discussion (Misc queries) 1 December 17th 05 12:04 AM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM
How do I access data stored in a SQL server for vlookup function? M.Heer Excel Worksheet Functions 8 May 12th 05 09:51 PM
Problem Code: Retrieving Stored Access 03 Query Bettergains Excel Discussion (Misc queries) 2 December 7th 04 04:11 PM


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