If you have a module and a subroutine/function named the same thing, then excel
can get confused.

Change the name of the module to something else:
Mod_error_h

Into the VBE
Show the project explorer (ctrl-r)
select your module
hit F4 to see its properties
Change the value in the (Name) box.



"Pierre via OfficeKB.com" wrote:

Hi norman,

yes i have a module called error_h but that is the module i would like to
execute !
any suggestions?
thanks,
Pierre

Norman Jones wrote:
Hi Pierre,

Do you also have a module named error_h?

If so, rename the module or the sub.

---
Regards,
Norman

Hi experts,
i have a button on a userform called 'cancel'
[quoted text clipped - 12 lines]
Any ideas?
ThanksPierre

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1

--

Dave Peterson