Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prepopulating a dropdown list in excel
How do I do that? I tried in workbook.open but can't reference the object. I
tried in worksheet_activate event , but you have to change the sheet and go back to the previous sheet to activate it. The worksheet doesn't have any onload event. Any help would be greatly appreciated. -- Nothing but .Net |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prepopulating a dropdown list in excel
Is there a specific reason why you can't reference the object from the
workbook_open event? The one thing to note when doing this is that you will probably need to be explicit in your reference to the object, including the sheet that it is on... Barring that in the on open you could just select and de-select the sheets you want, which would trigger the activate event for those sheets... HTH "Manny" wrote: How do I do that? I tried in workbook.open but can't reference the object. I tried in worksheet_activate event , but you have to change the sheet and go back to the previous sheet to activate it. The worksheet doesn't have any onload event. Any help would be greatly appreciated. -- Nothing but .Net |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dropdown list determined by another dropdown list | Excel Discussion (Misc queries) | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
creating a dropdown list in excel | Excel Discussion (Misc queries) | |||
excel dropdown list?? | Excel Programming |