| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListFillRange
I have the following code in a procdu
Sheets("Home").OLEObjects("ListBox1").ListFillRang e = Range("wrkshtrng").Address The listbox window is blank. I have been using: Sheets("Home").OLEObjects("ListBox1").ListFillRang e = "wrkshtrng" But I have been having problems. I don't know if that is the cause of the problems or not. Why is the first code not working? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ListFillRange
After I named a range "wrkshtrng", this line...
Sheets("Home").OLEObjects("ListBox1").ListFillRang e = Range("wrkshtrng").Address worked fine for me. Rick "ranswrt" wrote in message ... I have the following code in a procdu Sheets("Home").OLEObjects("ListBox1").ListFillRang e = Range("wrkshtrng").Address The listbox window is blank. I have been using: Sheets("Home").OLEObjects("ListBox1").ListFillRang e = "wrkshtrng" But I have been having problems. I don't know if that is the cause of the problems or not. Why is the first code not working? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ListFillRange
"wrkshtrng" is on a different sheet than the sheet with the listbox in, does
that make a difference? "Rick Rothstein (MVP - VB)" wrote: After I named a range "wrkshtrng", this line... Sheets("Home").OLEObjects("ListBox1").ListFillRang e = Range("wrkshtrng").Address worked fine for me. Rick "ranswrt" wrote in message ... I have the following code in a procdu Sheets("Home").OLEObjects("ListBox1").ListFillRang e = Range("wrkshtrng").Address The listbox window is blank. I have been using: Sheets("Home").OLEObjects("ListBox1").ListFillRang e = "wrkshtrng" But I have been having problems. I don't know if that is the cause of the problems or not. Why is the first code not working? Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ListFillRange
Did you try all the other suggestions at your earlier post?
Just curious. ranswrt wrote: I have the following code in a procdu Sheets("Home").OLEObjects("ListBox1").ListFillRang e = Range("wrkshtrng").Address The listbox window is blank. I have been using: Sheets("Home").OLEObjects("ListBox1").ListFillRang e = "wrkshtrng" But I have been having problems. I don't know if that is the cause of the problems or not. Why is the first code not working? Thanks -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ListFillRange
Yes
"Dave Peterson" wrote: Did you try all the other suggestions at your earlier post? Just curious. ranswrt wrote: I have the following code in a procdu Sheets("Home").OLEObjects("ListBox1").ListFillRang e = Range("wrkshtrng").Address The listbox window is blank. I have been using: Sheets("Home").OLEObjects("ListBox1").ListFillRang e = "wrkshtrng" But I have been having problems. I don't know if that is the cause of the problems or not. Why is the first code not working? Thanks -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ListFillRange
I call this procedure alot when I'm running other procedu
Sub stopautocalc() With Application .ScreenUpdating = False .EnableEvents = False .Calculation = xlCalculationManual End With End Sub Then I turn them back on again. Could this have anything to do with it? "Dave Peterson" wrote: Did you try all the other suggestions at your earlier post? Just curious. ranswrt wrote: I have the following code in a procdu Sheets("Home").OLEObjects("ListBox1").ListFillRang e = Range("wrkshtrng").Address The listbox window is blank. I have been using: Sheets("Home").OLEObjects("ListBox1").ListFillRang e = "wrkshtrng" But I have been having problems. I don't know if that is the cause of the problems or not. Why is the first code not working? Thanks -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ListFillRange
I don't think so.
You really tried: Sheets("Home").OLEObjects("ListBox1").ListFillRang e _ = Range("wrkshtrng").Address(external:=true) Or being more specific: Sheets("Home").OLEObjects("ListBox1").ListFillRang e _ = worksheets("somesheet").Range("wrkshtrng").Address (external:=true) ranswrt wrote: I call this procedure alot when I'm running other procedu Sub stopautocalc() With Application .ScreenUpdating = False .EnableEvents = False .Calculation = xlCalculationManual End With End Sub Then I turn them back on again. Could this have anything to do with it? "Dave Peterson" wrote: Did you try all the other suggestions at your earlier post? Just curious. ranswrt wrote: I have the following code in a procdu Sheets("Home").OLEObjects("ListBox1").ListFillRang e = Range("wrkshtrng").Address The listbox window is blank. I have been using: Sheets("Home").OLEObjects("ListBox1").ListFillRang e = "wrkshtrng" But I have been having problems. I don't know if that is the cause of the problems or not. Why is the first code not working? Thanks -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ListFillRange
I changed
Sheets("Current DB") to worksheets("Current DB") and added (external:=True) That seemed to have fixed the problem. Thanks for your help "Dave Peterson" wrote: I don't think so. You really tried: Sheets("Home").OLEObjects("ListBox1").ListFillRang e _ = Range("wrkshtrng").Address(external:=true) Or being more specific: Sheets("Home").OLEObjects("ListBox1").ListFillRang e _ = worksheets("somesheet").Range("wrkshtrng").Address (external:=true) ranswrt wrote: I call this procedure alot when I'm running other procedu Sub stopautocalc() With Application .ScreenUpdating = False .EnableEvents = False .Calculation = xlCalculationManual End With End Sub Then I turn them back on again. Could this have anything to do with it? "Dave Peterson" wrote: Did you try all the other suggestions at your earlier post? Just curious. ranswrt wrote: I have the following code in a procdu Sheets("Home").OLEObjects("ListBox1").ListFillRang e = Range("wrkshtrng").Address The listbox window is blank. I have been using: Sheets("Home").OLEObjects("ListBox1").ListFillRang e = "wrkshtrng" But I have been having problems. I don't know if that is the cause of the problems or not. Why is the first code not working? Thanks -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ListFillRange not working | Excel Programming | |||
| How to Set ListFillRange to Another Sheet | Excel Programming | |||
| I can't figure out listfillrange | Excel Programming | |||
| ListFillRange | Excel Programming | |||
| ListFillRange | Excel Programming | |||
Linear Mode
