Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a listbox on my worksheet and have added some items to it
using: Sub temp() With Sheets("Month").ListBox1 .AddItem ("Yesterday") .AddItem ("Today") .AddItem ("Tomorrow") End With End Sub That works fine but when I close the sheet and open it again the entries disappear. I can briefly see them and then the list is empty. I have removed all ThisWorkbook code and I disable macros when the spreadsheet opens. But the entries still disappear. What's going on? TIA, Derek |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Listbox 2 takes the value of Listbox 1 | Excel Discussion (Misc queries) | |||
listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |