View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default unload Me compile error

It would help if you posted your code.
--
HTH,
Barb Reinhardt



"Cinque Terra" wrote:

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.