ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Access items stored in combobox (https://www.excelbanter.com/excel-discussion-misc-queries/156981-access-items-stored-combobox.html)

Geoff

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.

Geoff

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.



All times are GMT +1. The time now is 07:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com