Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unload Me compile error
I have a UserForm that is loaded by an Worksheet_SelectionChange event.
Since the listboxes in the form are loaded with relative values, I want to unload the form when either the OK or Cancel button is clicked. I've tried both "unload me" and "unload frm_spread" in the button click events. When I input this into the code, "me" is updated to "Me" or "frm_spread" is updated to "frm_Spread"; "unload" remains "unload" (it isn't capitalized) When I run the code, I get: Compile error - wrong number of arguments or invalid property assignment. I'm running excel 2007. Thanks in advance for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting error with load/unload of UserForms?? | Excel Programming | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
VBAProject name compile error, not defined at compile time | Excel Programming | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |