Thread: listbox
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default listbox

You must enter Design Mode to add Ranges. When you first Add a listbox you
are in design Mode automatically and you can right click on the Listbox to
add ranges by Right Click on Listbox - Properties - ListFillRange. Enter
something like A1:A10.

to Add a Listbox or change ListFillRange do the following
1) Use toolbar "Control Toolbox". If you don't have one then go to View
Menu - Toolbars and select "Control Toolbox"
2) Pressing the triangle on the Toolbar toggles between Normal Mode and
Design Mode. Enter Design Mode
3) Right Click Listbox and Select Properties. If you can't do this then you
are not in Design Mode. Click the triangle again
4) ListFillRange. Enter something like A1:A10.
5) Press Triangle again to exit Design Mode.

"eggpap" wrote:

how to fill a listbox with one m x n range values?
thanks,
Emiliano