Userform

[Edgar Thoemmes]

Hi

I am having trouble calling a userform from a module. What
am i doing wrong?

Form_Suppliers.show

TIA

 

[Chip Pearson]

Edgar,

What specifically are you having trouble with? Do you get an
error message? Does the form show?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Edgar Thoemmes]

It says 'Object Required' and the form doesnt show

TIA

 

[Tom Ogilvy]

Is your userform name actually Form_Suppliers

Do you have code in the initialize event - is it causing an error.

 

[Chip Pearson]

Edgar,

Is your form named Form_Suppliers?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Edgar Thoemmes]

Yes definately, i tried changing the name but this didnt
work as well. I imported the form from another sheet if
that would make any difference?