Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I can't figure out listfillrange
I'm trying to create a listbox named ClientStatus from Control Toolbox
toolbar on worksheet 'Cover Info'. My list data is in column A of worksheet 'Data Formatting'. It won't let me enter anything in the ListFillRange under Properties, and I can not for the life of me figure out how to use the ListFillRange in VBA. (I'm new to all of this. Just learning by reading other's answers.) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I can't figure out listfillrange
hi,
is the listfillrange on the same sheet as your listbox. if it is on another sheet, it will "disapear" on you or reference the range on the same sheet with the list box. -----Original Message----- I'm trying to create a listbox named ClientStatus from Control Toolbox toolbar on worksheet 'Cover Info'. My list data is in column A of worksheet 'Data Formatting'. It won't let me enter anything in the ListFillRange under Properties, and I can not for the life of me figure out how to use the ListFillRange in VBA. (I'm new to all of this. Just learning by reading other's answers.) . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I can't figure out listfillrange
yes, it is on another sheet, and it does "disappear" on me. How do I get it
to pull from another sheet? " wrote: hi, is the listfillrange on the same sheet as your listbox. if it is on another sheet, it will "disapear" on you or reference the range on the same sheet with the list box. -----Original Message----- I'm trying to create a listbox named ClientStatus from Control Toolbox toolbar on worksheet 'Cover Info'. My list data is in column A of worksheet 'Data Formatting'. It won't let me enter anything in the ListFillRange under Properties, and I can not for the life of me figure out how to use the ListFillRange in VBA. (I'm new to all of this. Just learning by reading other's answers.) . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
I can't figure out listfillrange
I could manually type in the range that I wanted:
'Data Formatting'!A1:A13 (note the single quotes and exclamation mark) In code: With Worksheets("Cover Info").ListBox1 .ListFillRange = Worksheets("data formatting").Range("a1:a13") _ .Address(external:=True) End With LostinVA wrote: I'm trying to create a listbox named ClientStatus from Control Toolbox toolbar on worksheet 'Cover Info'. My list data is in column A of worksheet 'Data Formatting'. It won't let me enter anything in the ListFillRange under Properties, and I can not for the life of me figure out how to use the ListFillRange in VBA. (I'm new to all of this. Just learning by reading other's answers.) -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
I can't figure out listfillrange
Thanks so much, Dave! It's embarrassing that it was that simple, but when
you can't get it to work it seems so hard! "Dave Peterson" wrote: I could manually type in the range that I wanted: 'Data Formatting'!A1:A13 (note the single quotes and exclamation mark) In code: With Worksheets("Cover Info").ListBox1 .ListFillRange = Worksheets("data formatting").Range("a1:a13") _ .Address(external:=True) End With LostinVA wrote: I'm trying to create a listbox named ClientStatus from Control Toolbox toolbar on worksheet 'Cover Info'. My list data is in column A of worksheet 'Data Formatting'. It won't let me enter anything in the ListFillRange under Properties, and I can not for the life of me figure out how to use the ListFillRange in VBA. (I'm new to all of this. Just learning by reading other's answers.) -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
I can't figure out listfillrange
So how do you format that using UNC ("\\server\path\filename) to reference a
remote file (stored on a different drive) as the source? I keep getting a "Subscript out of range" error... "Dave Peterson" wrote: I could manually type in the range that I wanted: 'Data Formatting'!A1:A13 (note the single quotes and exclamation mark) In code: With Worksheets("Cover Info").ListBox1 .ListFillRange = Worksheets("data formatting").Range("a1:a13") _ .Address(external:=True) End With LostinVA wrote: I'm trying to create a listbox named ClientStatus from Control Toolbox toolbar on worksheet 'Cover Info'. My list data is in column A of worksheet 'Data Formatting'. It won't let me enter anything in the ListFillRange under Properties, and I can not for the life of me figure out how to use the ListFillRange in VBA. (I'm new to all of this. Just learning by reading other's answers.) -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
I can't figure out listfillrange
Good question! I hit the same problem later, and I haven't been able to
resolve it. "Chuck Hyre" wrote: So how do you format that using UNC ("\\server\path\filename) to reference a remote file (stored on a different drive) as the source? I keep getting a "Subscript out of range" error... "Dave Peterson" wrote: I could manually type in the range that I wanted: 'Data Formatting'!A1:A13 (note the single quotes and exclamation mark) In code: With Worksheets("Cover Info").ListBox1 .ListFillRange = Worksheets("data formatting").Range("a1:a13") _ .Address(external:=True) End With LostinVA wrote: I'm trying to create a listbox named ClientStatus from Control Toolbox toolbar on worksheet 'Cover Info'. My list data is in column A of worksheet 'Data Formatting'. It won't let me enter anything in the ListFillRange under Properties, and I can not for the life of me figure out how to use the ListFillRange in VBA. (I'm new to all of this. Just learning by reading other's answers.) -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox ListFillRange | Excel Discussion (Misc queries) | |||
Combo box - Listfillrange | Excel Discussion (Misc queries) | |||
ComboBox - Changing ListFillRange | Excel Programming | |||
ListFillRange | Excel Programming | |||
ListFillRange | Excel Programming |